--
-- Database: `advenup1_odm`
--

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `VariableID` int(11) NOT NULL,
  `DataValue` double NOT NULL,
  `CategoryDescription` text NOT NULL,
  KEY `VariableID` (`VariableID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `censorcodecv`
--

DROP TABLE IF EXISTS `censorcodecv`;
CREATE TABLE IF NOT EXISTS `censorcodecv` (
  `Term` varchar(50) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `censorcodecv`
--

INSERT INTO `censorcodecv` (`Term`, `Definition`) VALUES
('gt', 'greater than'),
('lt', 'less than'),
('nc', 'not censored'),
('nd', 'non-detect'),
('pnq', 'present but not quantified');

-- --------------------------------------------------------

--
-- Table structure for table `datatypecv`
--

DROP TABLE IF EXISTS `datatypecv`;
CREATE TABLE IF NOT EXISTS `datatypecv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `datatypecv`
--

INSERT INTO `datatypecv` (`Term`, `Definition`) VALUES
('Average', 'The values represent the average over a time interval, such as daily mean discharge or daily mean temperature.'),
('Best Easy Systematic Estimator', 'Best Easy Systematic Estimator BES = (Q1 +2Q2 +Q3)/4.  Q1, Q2, and Q3 are first, second, and third quartiles. See Woodcock, F. and Engel, C., 2005: Operational Consensus Forecasts.Weather and Forecasting, 20, 101-111. (http://www.bom.gov.au/nmoc/bulletins/60/article_by_Woodcock_in_Weather_and_Forecasting.pdf) and Wonnacott, T. H., and R. J. Wonnacott, 1972: Introductory Statistics. Wiley, 510 pp.'),
('Categorical', 'The values are categorical rather than continuous valued quantities. Mapping from Value values to categories is through the CategoryDefinitions table.'),
('Constant Over Interval', 'The values are quantities that can be interpreted as constant for all time, or over the time interval to a subsequent measurement of the same variable at the same site.'),
('Continuous', 'A quantity specified at a particular instant in time measured with sufficient frequency (small spacing) to be interpreted as a continuous record of the phenomenon.'),
('Cumulative', 'The values represent the cumulative value of a variable measured or calculated up to a given instant of time, such as cumulative volume of flow or cumulative precipitation.'),
('Incremental', 'The values represent the incremental value of a variable over a time interval, such as the incremental volume of flow or incremental precipitation.'),
('Maximum', 'The values are the maximum values occurring at some time during a time interval, such as annual maximum discharge or a daily maximum air temperature.'),
('Median', 'The values represent the median over a time interval, such as daily median discharge or daily median temperature.'),
('Minimum', 'The values are the minimum values occurring at some time during a time interval, such as 7-day low flow for a year or the daily minimum temperature.'),
('Mode', 'The values are the most frequent values occurring at some time during a time interval, such as annual most frequent wind direction.'),
('Sporadic', 'The phenomenon is sampled at a particular instant in time but with a frequency that is too coarse for interpreting the record as continuous.  This would be the case when the spacing is significantly larger than the support and the time scale of fluctuation of the phenomenon, such as for example infrequent water quality samples.'),
('StandardDeviation', 'The values represent the standard deviation of a set of observations made over a time interval. Standard deviation computed using the unbiased formula SQRT(SUM((Xi-mean)^2)/(n-1)) are preferred. The specific formula used to compute variance can be noted in the methods description.'),
('Unknown', 'The data type is unknown'),
('Variance', 'The values represent the variance of a set of observations made over a time interval.  Variance computed using the unbiased formula SUM((Xi-mean)^2)/(n-1) are preferred.  The specific formula used to compute variance can be noted in the methods description.');


--
-- Table structure for table `spanish`
--

CREATE TABLE IF NOT EXISTS `spanish` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `EngText` longtext NOT NULL,
  `SpanishText` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1368 ;

--
-- Dumping data for table `spanish`
--

INSERT INTO `spanish` (`ID`, `EngText`, `SpanishText`) VALUES
(1, ' Foliage Digestion', ' Digestión de Follaje'),
(2, ' Foliage Leaching', ' Lixiviado de Follaje'),
(3, ' Forest Floor Digestion', ' Digestión de Piso de Bosque'),
(4, ' Groundwater', ' Agua subterranea'),
(5, ' Litter Fall Digestion', ' Digestión de basura de Otoño'),
(6, ' or an aggregate site can be created for each county.', ' o se puede crear un sitio de agregado para cada municipio.'),
(7, ' or when water-use information is only available for the aggregate. Aggregate sites that span multiple counties should be coded with 000 as the county code', ' o cuando la información de uso de agua esta solamente disponible para el agregado. Los sitios de agregados que cubren varios municipios deben ser codificados con 000 como codigo de municipio'),
(8, ' Petri Dish (Dry Deposition)', ' Petri Dish (Deposición Seca)'),
(9, ' Precipitation Bulk', ' Volumen grueso de Precipitación'),
(10, ' Precipitation Event', ' Evento de Precipitación'),
(11, ' Precipitation Increment', ' Incremento de la Precipitación'),
(12, ' Precipitation Weekly', ' Precipitación semanal'),
(13, ' Rock Extraction', ' Extracción de roca'),
(14, ' Standard Reference', ' Referencia estandar'),
(15, ' Stemflow Event', ' Evento de escurrimiento'),
(16, ' Streamwater', ' Agua del cauce'),
(17, ' Throughfall Event', ' Evento de escurrimiento'),
(18, ' Throughfall Increment', ' Incremento de escurrimiento'),
(19, ' Throughfall Weekly', ' Escurrimiento Semanal'),
(20, ' Vadose Water Event', ' Evento de agua Vadosa'),
(21, ' Vadose Water Increment', ' Incremento de agua vadosa'),
(22, ' Vadose Water Weekly', ' Agua Vadosa Semanal'),
(23, '10^9 colonies/d', '10^9 colonias/d'),
(24, '15 Nitrogen, Delta Nitrogen', '15 Nitrogeno, Delta Nitrogeno'),
(25, '19-Hexanoyloxyfucoxanthin', '19-Hexanoilo Oxy Fucoxantina'),
(26, '1-day Biochemical Oxygen Demand', 'Demanda bioquimica de oxigeno 1-día'),
(27, '20-day Biochemical Oxygen Demand', '20-día Demanda Bioquímica de Oxígeno'),
(28, '20-day Carbonaceous Biochemical Oxygen Demand', '20-día Demanda Carbonosa Bioquímica de Oxígeno'),
(29, '20-day Nitrogenous Biochemical Oxygen Demand', '20-día Demanda Nitrogenosa Bioquímica de Oxígeno'),
(30, '2-day Carbonaceous Biochemical Oxygen Demand', '2-día Demanda Carbonosa Bioquímica de Oxígeno'),
(31, '3-day Carbonaceous Biochemical Oxygen Demand', '3-día Demanda Carbonosa Bioquímica de Oxígeno'),
(32, '4-day Carbonaceous Biological Oxygen Demand', '4-día Demanda Carbonosa Biológica de Oxígeno'),
(33, '5-day Biochemical Oxygen Demand', '5-Día Demanda Bioquimica de Oxigeno'),
(34, '5-day Carbonaceous Biochemical Oxygen Demand', '5-día Demanda Carbonosa Bioquímica de Oxígeno'),
(35, '5-day Nitrogenous Biochemical Oxygen Demand', '5-día Demanda Nitrogenosa Bioquímica de Oxígeno'),
(36, '6-day Carbonaceous Biological Oxygen Demand', '6-día Demanda Carbonosa Biological de Oxígeno'),
(37, '7-day Carbonaceous Biochemical Oxygen Demand', '7-día Demanda Carbonosa Bioquímica de Oxígeno'),
(38, '9 cis-Neoxanthin', '9 cis-Neoxantina'),
(39, 'A body of running water moving under gravity flow in a defined channel. The channel may be entirely natural, or altered by engineering practices through straightening, dredging, and (or) lining. An entirely artificial channel should be qualified with the "canal" or "ditch" secondary site type.', 'Un cuerpo de agua corriente en movimiento bajo flujo por gravedad en un canal definido. El canal puede ser totalmente natural, o alterado por prácticas de ingeniería a través de enderezamiento, dragado y (o) del revestimiento. Un canal totalmente artificial debe ser calificada con ''canales'' o ''zanja'' tipo de sitio secundario.'),
(40, 'A coastal inlet of the sea or ocean; esp. the mouth of a river, where tide water normally mixes with stream water (modified, Webster). Salinity in estuaries typically ranges from 1 to 25 Practical Salinity units (psu), as compared oceanic values around 35-psu. See also: tidal stream and coastal.', 'Un entrante de la costa del mar o el océano, esp. la desembocadura de un río, donde el agua corriente se mezcla normalmente con agua corriente (modificado, Webster). La salinidad en los estuarios suele oscilar de 1 a 25 unidades prácticas de salinidad (ups), como valores oceánicas frente alrededor de 35 ups. Ver también: corriente de marea y costeras.'),
(41, 'A code used to identifier a data recorder.', 'Un código usado para identificar un registrador de datos.'),
(42, 'A constructed subsurface open space large enough to accommodate a human that is not substantially open to the atmosphere and is not a well. The excavation may have been for minerals, transportation, or other purposes. See also: Excavation.', 'Un construida espacio abierto debajo de la superficie lo suficientemente grande como para dar cabida a un ser humano que no está abierto sustancialmente a la atmósfera y no es un pozo. La excavación puede haber sido para los minerales, transporte, u otros propósitos. Ver también: Excavación.'),
(43, 'A counter of events in a sequence', 'Un contador de eventos en una secuencia'),
(44, 'A counter of the number of times the battery voltage dropped below a minimum threshold', 'Un contador del numero de veces que el voltage de la bateria cae por debajo de un umbral minimo'),
(45, 'A counter which counts the number of ', 'Un contador que cuenta el numero de  '),
(46, 'A counter which counts the number of datalogger table overrun errors', 'Un contador que cuenta el numero de errores de saturación de tabla de datalogger'),
(47, 'A counter which counts the number of total datalogger watchdog errors', 'Un contador que cuenta el numero total de errores de vigilancia de datalogger'),
(48, 'A crater formed when the roof of a cavern collapses; usually found in limestone areas. Surface water and precipitation that enters a sinkhole usually evaporates or infiltrates into the ground, rather than draining into a stream.', 'Un cráter se formó cuando el techo de una cueva se derrumba, por lo general se encuentra en zonas de piedra caliza. El agua superficial y la precipitación que entra en un sumidero por lo general se evapora o se infiltra en el suelo, en lugar de drenaje en una corriente.'),
(49, 'A dried-up, vegetation-free, flat-floored area composed of thin, evenly stratified sheets of fine clay, silt or sand, and represents the bottom part of a shallow, completely closed or undrained desert lake basin in which water accumulates and is quickly evaporated, usually leaving deposits of soluble salts.', 'Una vegetación zona libre con suelo llano reseco,, compuesto de hojas finas, uniformemente estratificadas de arcilla fina, limo o arena, y representa la parte inferior de un desierto cuenca del lago de poca profundidad, completamente cerrada o sin escurrir en que el agua se acumula y es se evaporó rápidamente, por lo general dejando depósitos de sales solubles.'),
(50, 'A facility for storage and/or biological treatment of wastes from livestock operations. Animal-waste lagoons are earthen structures ranging from pits to large ponds, and contain manure which has been diluted with building washwater, rainfall, and surface runoff. In treatment lagoons, the waste becomes partially liquefied and stabilized by bacterial action before the waste is disposed of on the land and the water is discharged or re-used.', 'Una instalación para el almacenamiento y / o el tratamiento biológico de los desechos de las operaciones ganaderas. Lagunas de desechos animales son estructuras de tierra que van desde pozos a grandes estanques, y contienen estiércol que se ha diluido con el agua de lavado de construcción, las precipitaciones y la escorrentía superficial. En lagunas de tratamiento, los residuos se convierte parcialmente licuado y estabilizado por la acción bacteriana antes de los residuos se eliminan en la tierra y el agua se descarga o reutilización.'),
(51, 'A facility that generates electric power by converting potential energy of water into kinetic energy. Typically, turbine generators are turned by falling water.', 'Una instalación que genera energía eléctrica mediante la conversión de energía potencial del agua en energía cinética. Por lo general, los generadores de turbinas se encienden por el agua que cae.'),
(52, 'A facility that uses water in the generation of electricity from heat. Typically turbine generators are driven by steam. The heat may be caused by various means, including combustion, nuclear reactions, and geothermal processes.', 'Una instalación que utiliza el agua en la generación de electricidad a partir del calor. Típicamente generadores de turbinas son accionadas por vapor de agua. El calor puede ser causada por diversos medios, incluyendo la combustión, las reacciones nucleares, y procesos geotérmicos.'),
(53, 'A facility used to convey industrial waste, domestic sewage, brine, mine drainage, radioactive waste, or other fluid into an underground zone. An oil-test or deep-water well converted to waste disposal should be in this category. A well where fresh water is injected to artificially recharge thegroundwaterr supply or to pressurize an oil or gas production zone by injecting a fluid should be classified as a well (not an injection-well facility), with additional information recorded under Use of Site.', 'Una instalación utilizada para transmitir los residuos industriales, aguas residuales domésticas, salmuera, drenaje de la mina, los residuos radiactivos, u otro fluido en una zona subterránea. Una prueba de aceite o de aguas profundas y convertido a la eliminación de residuos deben estar en esta categoría. Un pozo en el que se inyecta el agua dulce para recargar artificialmente el suministro thegroundwaterr o para presionar a una zona de producción de petróleo o gas mediante la inyección de un fluido que debe ser clasificado como un bien (no es una instalación de inyección pocillos), con la información adicional registrada bajo uso del Sitio.'),
(54, 'A facility where wastewater is treated to reduce concentrations of dissolved and (or) suspended materials prior to discharge or reuse.', 'Una instalación donde las aguas residuales es tratada para reducir las concentraciones de materiales suspendidos y disueltos (o) antes de la descarga o reutilización.'),
(55, 'A facility where water is treated prior to use for consumption or other purpose.', 'Una instalación donde el agua es tratada antes de su uso para el consumo o para otros fines.'),
(56, 'A group of wells that are pumped through a single header and for which little or no data about the individual wells are available.', 'Un grupo de pozos que son bombeados a través de un único encabezado y para el que pocos o ningún dato acerca de los pocillos individuales están disponibles.'),
(57, 'A hole or shaft constructed in the earth intended to be used to locate, sample, or develop groundwater, oil, gas, or some other subsurface material. The diameter of a well is typically much smaller than the depth. Wells are also used to artificially recharge groundwater or to pressurize oil and gas production zones. Additional information about specific kinds of wells should be recorded under the secondary site types or the Use of Site field. Underground waste-disposal wells should be classified as waste-injection wells.', 'Un taladro o el eje construido en la tierra destinados a ser utilizados para localizar, de la muestra, o el desarrollo de las aguas subterráneas, petróleo, gas, o algún otro material subsuperficial. El diámetro de un pozo es típicamente mucho menor que la profundidad. Wells también se utilizan para recargar artificialmente aguas subterráneas o para presionar a las zonas de producción de petróleo y gas. Información adicional sobre los tipos específicos de pozos deben registrarse en los tipos de sitios secundarios o el uso de terreno del sitio. Pozos de eliminación de residuos subterráneos deben ser clasificados como residuos pozos de inyección.'),
(58, 'A location at which the water table intersects the land surface, resulting in a natural flow of groundwater to the surface. Springs may be perennial, intermittent, or ephemeral.', 'Una ubicación en la que la tabla de agua se cruza con la superficie de la tierra, lo que resulta en un flujo natural de las aguas subterráneas a la superficie. Los manantiales pueden ser perennes, intermitentes o efímeros.'),
(59, 'A location below the land surface, but not a well, soil hole, or excavation.', 'Una ubicación por debajo de la superficie de la tierra, pero no un pozo, agujero del suelo, o excavación.'),
(60, 'A location on the surface of the earth that is not normally saturated with water. Land sites are appropriate for sampling vegetation, overland flow of water, or measuring land-surface properties such as temperature. (See also: Wetland).', 'Una localización en la superficie de la tierra que no está normalmente saturado con agua. Sitios de la tierra son apropiados para muestreo de la vegetación, el flujo superficial de agua, o que miden las propiedades de la superficie terrestre, como la temperatura. (Ver también: Humedal).'),
(61, 'A measure of the intensity of rainfall, calculated as the depth of water to fall over a given time period if the intensity were to remain constant over that time interval (in/hr, mm/hr, etc)', 'Una medida de la intensidad de la lluvia, calculada como la profundidad del agua sobre un periodo de tiempo dado si la intensidad fuera a permenecer constante a lo largo del intervalo de tiempo (pulg/hr, mm/hr, etc)'),
(62, 'A mixture of formation water and hydraulic fracturing injectates deriving from oil and gas wells prior to placing wells into production', 'Una mezcla de formación de agua e hidráulica fracturando inyectados derivandose desde aceite y pozos de gas previo a colocar pozos en producción'),
(63, 'A natural open space within a rock formation large enough to accommodate a human. A cave may have an opening to the outside, is always underground, and sometimes submerged. Caves commonly occur by the dissolution of soluble rocks, generally limestone, but may also be created within the voids of large-rock aggregations, in openings along seismic faults, and in lava formations.', 'Un espacio abierto natural dentro de una formación de roca lo suficientemente grande como para dar cabida a un ser humano. Una cueva puede tener una abertura hacia el exterior, es siempre bajo tierra, y, a veces sumergido. Cuevas comúnmente se producen por la disolución de rocas solubles, generalmente de piedra caliza, pero también pueden ser creados dentro de los huecos de las agregaciones de gran roca, en aberturas a lo largo de fallas sísmicas, y en formaciones de lava.'),
(64, 'A non-ambient location where environmental measurements are expected to be strongly influenced by current or previous activities of humans. *Sites identified with a "facility" primary site type must be further classified with one of the applicable secondary site types.', 'Un lugar que no ambiente donde se espera que las medidas ambientales a ser fuertemente influenciado por las actividades actuales o anteriores de los seres humanos. * Sitios identificados con una ''instalación'' tipo de sitio primario deben ser clasificados con uno de los tipos de sitios secundarios aplicables.'),
(65, 'A permanent well, drive point, or other device intended to sample a saturated zone in close proximity to a stream.', 'Un bien permanente, el punto de accionamiento, o cualquier otro dispositivo destinado a probar una zona saturada en estrecha proximidad a una corriente.'),
(66, 'A place-of-use (a water using facility that is associated with a specific geographical point location, such as a business or industrial user) that cannot be specified with any other facility secondary type. Water-use place-of-use sites are establishments such as a factory, mill, store, warehouse, farm, ranch, or bank. A place-of-use site is further classified using the national water-use category code (C39) and optionally classified using the Standard Industrial Classification System Code (SIC code) or North American Classification System Code (NAICS code). See also: Aggregate water-use-establishment.', 'Un lugar de uso (un agua utilizando instalaciones que se asocia con la ubicación de un punto geográfico específico, como un negocio o un usuario industrial) que no se puede especificar con cualquier otro tipo secundario instalación. El uso del agua sitios lugar de uso son establecimientos como una fábrica, molino, tienda, almacén, granja, rancho, o el banco. Un sitio de lugar de uso se clasifica utilizando el código de categoría de uso de aguas nacionales (C39) y, opcionalmente, clasificados de acuerdo al Código de Clasificación Industrial Estándar System (código SIC) o norteamericano Código de Clasificación del sistema (código NAICS). Ver también: Agregado el uso del agua al establecimiento.'),
(67, 'A place-of-use, either public or private, where the game of golf is played. A golf course typically uses water for irrigation purposes. Should not be used if the site is a specific hydrologic feature or facility; but can be used especially for the water-use sites.', 'Un lugar de uso, ya sea pública o privada, donde se juega el juego del golf. Un campo de golf por lo general utiliza el agua para el riego. No se debe utilizar si el sitio es una característica o servicio hidrológico específico, pero puede ser utilizado sobre todo para los sitios de uso del agua.'),
(68, 'A quantity specified at a particular instant in time measured with sufficient frequency (small spacing) to be interpreted as a continuous record of the phenomenon.', 'Una cantidad especificada en un instante particular en el tiempo medido con suficiente frecuencia (pequeño espaciamiento) para ser interpretado como registro continuo del fenomeno.'),
(69, 'A site equipped to measure conditions in the subsurface deeper than a soil hole, but above the water table or other zone of saturation.', 'Un sitio equipado para medir las condiciones en el subsuelo más profundo que un agujero del suelo, pero por encima de la mesa de agua u otra zona de saturación.'),
(70, 'A site established primarily to measure meteorological properties or atmospheric deposition.', 'Un sitio creado principalmente para medir las propiedades meteorológicas o la deposición atmosférica.'),
(71, 'A site located somewhere on a networked infrastructure that distributes treated or untreated water to multiple domestic, industrial, institutional, and (or) commercial users. May be owned by a municipality or community, a water district, or a private concern.', 'Un sitio ubicado en algún lugar de una infraestructura de red que distribuye el agua tratada o no tratada para múltiples usuarios domésticos, industriales, institucionales, y (o) comerciales. Puede ser propiedad de un municipio o comunidad, un distrito de agua, o una empresa privada.'),
(72, 'A site where some types of quality-control samples are collected, and where equipment and supplies for environmental sampling are prepared. Equipment blank samples are commonly collected at this site type, as are samples of locally produced deionized water. This site type is typically used when the data are either not associated with a unique environmental data-collection site, or where blank water supplies are designated by Center offices with unique station IDs.', 'Un sitio en el que se recogen algunos tipos de muestras de control de calidad, y donde se preparan los equipos y suministros para el muestreo ambiental. Los blancos de equipo se reúnen habitualmente en este tipo de sitio, al igual que las muestras de agua desionizada de producción local. Este tipo de sitio se utiliza cuando los datos están o no asociados a un sitio de recopilación de datos del medio ambiente único, o donde el abastecimiento de agua en blanco son designados por las oficinas del Centro con ID de estación única.'),
(73, 'A site where the disposal of waste water on land occurs. Use "waste-injection well" for underground waste-disposal sites.', 'Un sitio donde se produce el vertido de aguas residuales en la tierra. Utilice ''así los residuos de la inyección'' para los sitios de eliminación de residuos subterráneos.'),
(74, 'A site where water is withdrawn or diverted from a surface-water body (e.g. the point where the upstream end of a canal intersects a stream, or point where water is withdrawn from a reservoir). Includes sites where water is pumped for use elsewhere.', 'Un sitio donde se retira o se desvía el agua de un cuerpo de agua superficial (por ejemplo, el punto en el que el extremo corriente arriba de un canal se cruza una corriente, o el punto donde el agua se extrae de un depósito). Incluye sitios donde el agua es bombeada para su uso en otros lugares.'),
(75, 'A site where water or wastewater is returned to a surface-water body, e.g. the point where wastewater is returned to a stream. Typically, the discharge end of an effluent pipe.', 'Un sitio donde el agua o agua residual se devuelve a un cuerpo de agua superficial, por ejemplo, el punto en que las aguas residuales se devuelve a un arroyo. Típicamente, el extremo de descarga de un tubo de efluente.'),
(76, 'A site within or in close proximity to a subsurface sewage disposal system that generally consists of: (1) a septic tank where settling of solid material occurs, (2) a distribution system that transfers fluid from the tank to (3) a leaching system that disperses the effluent into the ground.', 'Un sitio dentro o en estrecha proximidad a un sistema de eliminación de aguas residuales del subsuelo que por lo general consiste en: (1) un tanque séptico donde la sedimentación de material sólido se produce, (2) un sistema de distribución que transfiere el fluido desde el tanque hasta (3) un sistema de lixiviación que se dispersa el efluente en el suelo.'),
(77, 'A small excavation into soil at the top few meters of earth surface. Soil generally includes some organic matter derived from plants. Soil holes are created to measure soil composition and properties. Sometimes electronic probes are inserted into soil holes to measure physical properties, and (or) the extracted soil is analyzed.', 'Una pequeña excavación en el suelo en la parte superior unos metros de la superficie de la tierra. Suelo generalmente incluye alguna materia orgánica de origen vegetal. Agujeros del suelo se crean para medir la composición y las propiedades del suelo. A veces sondas electrónicas se insertan en los agujeros del suelo para medir las propiedades físicas, y (o) la tierra extraída se analiza.'),
(78, 'A stream reach where the flow is influenced by the tide, but where the water chemistry is not normally influenced. A site where ocean water typically mixes with stream water should be coded as an estuary.', 'Una corriente de llegar donde el flujo está influenciada por la marea, pero donde la química del agua no está normalmente influenciada. Un sitio donde el agua del océano normalmente se mezcla con agua corriente debe ser codificado como un estuario.'),
(79, 'A surface site where the land surface is covered by a relatively impermeable material, such as concrete or asphalt. Pavement sites are typically part of transportation infrastructure, such as roadways, parking lots, or runways.', 'Un sitio de superficie, donde la superficie de la tierra está cubierta por un material relativamente impermeable, tal como hormigón o asfalto. Sitios pavimento son típicamente parte de la infraestructura de transporte, como carreteras, aparcamientos, o pistas de aterrizaje.'),
(80, 'A typically dry location on the surface of the land where primarily solid waste products are currently, or previously have been, aggregated and sometimes covered with a veneer of soil. See also: Wastewater disposal and waste-injection well.', 'Una ubicación normalmente seco en la superficie de la tierra donde los residuos sólidos son principalmente actualmente o anteriormente han sido agregada y, a veces cubierto de una capa de suelo. Ver también: Disposición de aguas residuales y de los residuos de la inyección así.'),
(81, 'A unique data recorder program identifier which is useful for knowing when the source code in the data recorder has been modified.', 'Un identificador unico del progama registrador de datos que es util para conocer cuando el codigo fuente en el registrador de datos ha sido modificado.'),
(82, 'A value used as part of the calibration of an instrument at a particular time.', 'Un valor usado como parte de la calibración de un instrumento en un tiempo particular.'),
(83, 'A water-using facility characterized by an area where plants are grown for transplanting, for use as stocks for budding and grafting, or for sale. Irrigation water may or may not be applied.', 'Una instalación-utilizando agua que se caracteriza por un área donde se cultivan las plantas para trasplantar, para su uso como poblaciones para las gemación e injerto, o para la venta. El agua de riego puede o no se puede aplicar.'),
(84, 'A well equipped to measure small changes in the thickness of the penetrated sediments, such as those caused by groundwater withdrawal or recharge.', 'Un bien equipado para medir pequeños cambios en el espesor de los sedimentos penetradas, tales como los causados ??por la extracción de aguas subterráneas o recarga.'),
(85, 'Absorbance', 'Absorbancia'),
(86, 'absorbance per centimeter', 'absorbancia por centimetro'),
(87, 'absorbance per centimeter per mg/L of given acid ', 'absorbancia por centimetro por mg/L de acido dado'),
(88, 'Acid neutralizing capacity', 'Capacidad de Neutralización de Ácido'),
(89, 'Acid neutralizing capacity ', 'Capcidad de neutralización del ácido'),
(90, 'acre feet per half month', 'acre pies por half mes'),
(91, 'acre feet per month', 'acre pies por mes'),
(92, 'acre feet per year', 'acre pies por año'),
(93, 'acre foot', 'acre pie'),
(94, 'Agency code', 'Código de Agencia'),
(95, 'Aggregate groundwater use', 'Agua Subterránea Agregada'),
(96, 'Aggregate surface-water-use', 'Agua Superficial Agregada'),
(97, 'Aggregate water-use establishment', 'Agua Establecimiento Agregada'),
(98, 'Air', 'Aire'),
(99, 'Air contained in the soil pores', 'Aire contenenida en los poros del suelo'),
(100, 'Albuminoid Nitrogen', 'Nitrógeno Albuminoide'),
(101, 'Alkalinity, bicarbonate', 'Alcalinidad, Bicarbonato'),
(102, 'Alkalinity, carbonate ', 'Alcalinidad, carbonato '),
(103, 'Alkalinity, carbonate plus bicarbonate', 'Alcalinidad, de carbonato mas bicarbonato'),
(104, 'Alkalinity, hydroxide ', 'Alcalinidad, Hidroxido '),
(105, 'Alkalinity, total ', 'Alcalinidad, Total '),
(106, 'alphas per meter', 'alfas por metro'),
(107, 'Aluminium', 'Aluminio'),
(108, 'Aluminium (Al)', 'Aluminio (Al)'),
(109, 'Aluminum, dissolved', 'Aluminio, Disuelto'),
(110, 'Ammonium (NH4)', 'Amonio (NH4)'),
(111, 'Ammonium (NH4) flux', 'Amonio (NH4) flujo'),
(112, 'Ammonium flux', 'Aluminio Flujo'),
(113, 'Amount', 'Monto'),
(114, 'An Aggregate Groundwater Withdrawal/Return site represents an aggregate of specific sites whe groundwater is withdrawn or returned which is defined by a geographic area or some other common characteristic. An aggregate groundwatergroundwater site type is used when it is not possible or practical to describe the specific sites as springs or as any type of well including ''''multiple wells''', 'Un sitio agregado de Derivación/Retorno de agua subterranea representa un agregado de sitios específicos donde se extrae o se retorna agua subterranea, el cual esta definido por un area geografica o alguna otra caracteristica común. Un tipo de sitio agregado de agua subterranea es usado cuando no es posible o practico describir los sitios especificos como manantiales o como cualquier tipo de pozo incluyendo ''''pozos múltiples'''),
(115, 'An Aggregate Surface-Water Diversion/Return site represents an aggregate of specific sites where surface water is diverted or returned which is defined by a geographic area or some other common characteristic. An aggregate surface-water site type is used when it is not possible or practical to describe the specific sites as diversions, outfalls, or land application sites, or when water-use information is only available for the aggregate. Aggregate sites that span multiple counties should be coded with 000 as the county code, or an aggregate site can be created for each county.', 'Un sitio agregado de Derivación/Retorno de agua superficial Derivación/Retorno representa un agregado de sitios específicos donde se deriva o se retorna agua superficial , el cual esta definido por un area geografica o alguna otra caracteristica común. Un tipo de sitio agregado de agua superficial es usado cuando no es posible o practico describir los sitios especificos como derivaciones, caídas de eagua, o sitios de aplicación de terreno, o cuando la información de uso de agua esta solamente disponible para el agregado. Los sitios de agregados que cubren varios municipios deben ser codificados con 000 como codigo de municipio, o se puede crear un sitio de agregado para cada municipio.'),
(116, 'An Aggregate Water-Use Establishment represents an aggregate class of water-using establishments or individuals that are associated with a specific geographic location and water-use category, such as all the industrial users located within a county or all self-supplied domestic users in a county. The aggregate class of water-using establishments is identified using the national water-use category code and optionally classified using the Standard Industrial Classification System Code (SIC code) or North American Classification System Code (NAICS code). An aggregate water-use establishment site type is used when specific information needed to create sites for the individual facilities or users is not available or when it is not desirable to store the site-specific information in the database. Data entry rules that apply to water-use establishments also apply to aggregate water-use establishments. Aggregate sites that span multiple counties should be coded with 000 as the county code, or an aggregate site can be created for each county.', 'El Uso de Agua Establecimiento agregada representa una clase de agregado de agua que utilizan los establecimientos o personas que se asocian con una ubicación geográfica específica y categoría de uso de agua, como todos los usuarios industriales ubicados dentro de un condado o de todos los usuarios domésticos de autoabastecimiento en un condado. La clase de agregado de agua que utilizan los establecimientos se identifica mediante el uso de agua de código nacional categoría y, opcionalmente, clasificados de acuerdo al Código de Clasificación Industrial Estándar System (código SIC) o norteamericano Código de Clasificación del sistema (código NAICS). Un establecimiento del uso del agua tipo de sitio agregada se utiliza cuando la información específica que se necesita para crear sitios para las instalaciones individuales o usuarios no está disponible o cuando no es conveniente almacenar la información específica de la base de datos. Reglas de entrada de datos que se aplican a los establecimientos de consumo de agua también se aplican a los establecimientos totales del uso del agua. Sitios agregados que abarcan varios condados deben codificarse con 000 como el código de condado, o un sitio de agregado se pueden crear para cada condado.'),
(117, 'An artificial watercourse designed for navigation, drainage, or irrigation by connecting two or more bodies of water; it is larger than a ditch.', 'Un curso de agua artificial para la navegación, drenaje o de riego mediante la conexión de dos o más cuerpos de agua, sino que es más grande que una zanja.'),
(118, 'An artificial, non-pressurized reservoir filled by gravity flow and used for water storage. The reservoir may be located above, at, or below ground level. The water may be supplied from diversion of precipitation, surface, or groundwater sources.', 'Una, depósito no presurizado artificial llenado por flujo por gravedad y se utiliza para el almacenamiento de agua. El depósito puede estar situado por encima de, sobre o bajo el nivel del suelo. El agua puede ser suministrada a partir de la desviación de precipitación, superficie, aguas subterráneas o fuentes.'),
(119, 'An artificially constructed cavity in the earth that is deeper than the soil (see soil hole), larger than a well bore (see well and test hole), and substantially open to the atmosphere. The diameter of an excavation is typically similar or larger than the depth. Excavations include building-foundation diggings, roadway cuts, and surface mines.', 'Una cavidad construido artificialmente en la tierra que es más profundo que el suelo (ver el orificio de suelo), más grande que un diámetro pocillos (ver bien y el agujero de prueba), y sustancialmente abiertas a la atmósfera. El diámetro de una excavación es típicamente similar o mayor que la profundidad. Las excavaciones incluyen excavaciones edificio de la fundación, los cortes de carretera y minas de superficie.'),
(120, 'An excavation artificially dug in the ground, either lined or unlined, for conveying water for drainage or irrigation; it is smaller than a canal.', 'Una excavación excavado artificialmente en el suelo, ya sea alineado o sin forro, para el transporte de agua para el drenaje o el riego, que es más pequeño que un canal.'),
(121, 'An infiltration gallery consisting of one or more underground laterals through which groundwater is collected and a vertical caisson from which groundwater is removed. Also known as a "horizontal well". These wells produce large yield with small drawdown.', 'Una galería de infiltración que consiste en uno o más laterales subterráneas a través de los que se recoge el agua subterránea y un cajón vertical desde el cual se elimina el agua subterránea. También conocido como ''pozo horizontal''. Estos pozos producen gran rendimiento con una pequeña reducción.'),
(122, 'An inland body of standing fresh or saline water that is generally too deep to permit submerged aquatic vegetation to take root across the entire body (cf: wetland). This site type includes an expanded part of a river, a reservoir behind a dam, and a natural or excavated depression containing a water body without surface-water inlet and/or outlet.', 'El cuerpo interior de agua estancada dulce o salina que generalmente es demasiado profundo para permitir que la vegetación acuática sumergida a echar raíces en todo el cuerpo (cf: humedales). Este tipo de sitio incluye una parte expandida de un río, un embalse detrás de una presa, y una depresión natural o excavado que contiene un cuerpo de agua sin entrada de agua superficial y / o salida.'),
(123, 'An oceanic site that is located off-shore beyond the tidal mixing zone (estuary) but close enough to the shore that the investigator considers the presence of the coast to be important. Coastal sites typically are within three nautical miles of the shore.', 'Un sitio oceánico que se encuentra en alta mar más allá de la zona de mezcla de marea (estuario), pero lo suficientemente cerca de la costa que el investigador considera que la presencia de la costa para ser importante. Los sitios costeros son típicamente menos de tres millas náuticas de la costa.'),
(124, 'An uncased hole (or one cased only temporarily) that was drilled for water, or for geologic or hydrogeologic testing. It may be equipped temporarily with a pump in order to make a pumping test, but if the hole is destroyed after testing is completed, it is still a test hole. A core hole drilled as a part of mining or quarrying exploration work should be in this class.', 'Un agujero sin entubar (o un entubado sólo temporalmente) que fue perforado por el agua, o para las pruebas geológicas o hidrogeológicas. Podrá estar equipado temporalmente con una bomba con el fin de hacer una prueba de bombeo, pero si el agujero se destruye después de finalizar el análisis, es todavía un agujero de prueba. Un agujero central perforado como parte de la minería o canteras trabajos de exploración debería estar en esta clase.'),
(125, 'An underground conduit created to convey liquid and semisolid domestic, commercial, or industrial waste into a treatment plant, stream, reservoir, or disposal site. If the sewer also conveys storm water, then the "combined sewer" secondary site type should be used.', 'Un conducto subterráneo creado para transmitir los residuos domésticos, comerciales o industriales líquidos y semisólidos en una planta de tratamiento, corriente, depósito o vertedero. Si la red de alcantarillado de aguas pluviales también transmite, a continuación, se debe utilizar la ''cloaca combinada'' tipo de sitio secundario.'),
(126, 'An underground conduit created to convey storm drainage and waste products into a wastewater-treatment plant, stream, reservoir, or disposal site.', 'Un conducto subterráneo creado para transmitir drenaje y residuos en una planta de tratamiento de aguas residuales, corriente, depósito o vertedero.'),
(127, 'An underground conduit created to convey storm drainage into a stream channel or reservoir. If the sewer also conveys liquid waste products, then the "combined sewer" secondary site type should be used.', 'Un conducto subterráneo creado para transmitir de drenaje en un curso de agua o reservorio. Si la red de alcantarillado también transmite los productos de desecho líquidos, a continuación, se debe utilizar el ''combinado de alcantarillas'' tipo de sitio secundario.'),
(128, 'An underground pipe or tunnel through which groundwater is artificially diverted to surface water for the purpose of reducing erosion or lowering the water table. A drain is typically open to the atmosphere at the lowest elevation, in contrast to a well which is open at the highest point.', 'Una tubería subterránea o túnel a través del cual se desvía el agua subterránea artificialmente a las aguas superficiales con el fin de reducir la erosión o la reducción de la capa freática. Un drenaje está típicamente abierto a la atmósfera en la elevación más baja, en contraste con un pozo que está abierto en el punto más alto.'),
(129, 'Angle', 'Angulo'),
(130, 'Animal waste lagoon', 'Laguna de Residuos Animales'),
(131, 'Antimony', 'Antimonio'),
(132, 'Antimony (Sb)', 'Antimonio (Sb)'),
(133, 'arcminute', 'arcominuto'),
(134, 'arcsecond', 'arcosegundo'),
(135, 'Area of a measurement location', 'Area de localización de una medida'),
(136, 'Areal coverage of dead vegetation', 'Cobertura areal de vegetación muerta'),
(137, 'Areal coverage of no vegetation', 'Cobertura aereal de no vegetación'),
(138, 'Areal coverage of the plant Asteridae', 'Cobertura aereal de la planta Asteridae'),
(139, 'Areal coverage of the plant Batis maritima', 'Cobertura aereal de la planta Batis maritima'),
(140, 'Areal coverage of the plant Borrichia frutescens', 'Cobertura áereal de la planta Borrichia frutescens'),
(141, 'Areal coverage of the plant Cuscuta spp.', 'Cobertura aereal de la planta Cuscuta spp.'),
(142, 'Areal coverage of the plant Distichlis spicata', 'Cobertura áereal de la planta Distichlis spicata'),
(143, 'Areal coverage of the plant Iva frutescens', 'Cobertura aereal de la planta Iva frutescens'),
(144, 'Areal coverage of the plant Limonium nashii', 'Cobertura aereal de la planta Limonium nashii'),
(145, 'Areal coverage of the plant Lycium carolinianum', 'Cobertura aereal de la planta Lycium carolinianum'),
(146, 'Areal coverage of the plant Monanthochloe littoralis', 'Cobertura aereal de la planta Monanthochloe littoralis'),
(147, 'Areal coverage of the plant Salicornia bigelovii', 'Cobertura aereal de la planta Salicornia bigelovii'),
(148, 'Areal coverage of the plant Salicornia virginica', 'Cobertura aereal de la planta Salicornia virginica'),
(149, 'Areal coverage of the plant Spartina alterniflora', 'Cobertura áereal de la planta Spartina alterniflora'),
(150, 'Areal coverage of the plant Spartina spartinea', 'Cobertura áereal de la planta Spartina spartinea'),
(151, 'Areal coverage of the plant Suaeda linearis', 'Cobertura áereal de la planta Suaeda linearis'),
(152, 'Areal coverage of the plant Suaeda maritima', 'Cobertura áereal de la planta Suaeda maritima'),
(153, 'Areal coverage of transient species', 'Cobertura áereal de transient species'),
(154, 'Areal Density', 'Densidad Aereal'),
(155, 'Areal Loading', 'Carga Aereal'),
(156, 'Arsenic', 'Arsénico'),
(157, 'Arsenic (As)', 'Arsénico (As)'),
(158, 'Asteridae coverage', 'Cobertura de Asteridae'),
(159, 'Atmosphere', 'Atmósfera'),
(160, 'atmospheres', 'atmosferas'),
(161, 'atomic mass unit', 'unidad de masa atomica'),
(162, 'attenuation units', 'atenuacion units'),
(163, 'Average', 'Media'),
(164, 'Barium, dissolved', 'Bario, Disuelto'),
(165, 'Barium, total', 'Bario, Total'),
(166, 'Barometric pressure', 'Presión Barométrica'),
(167, 'barrel', 'barril'),
(168, 'Baseflow', 'Caudal Base'),
(169, 'Batis maritima Coverage', 'Cobertura de Batis Maritima'),
(170, 'Battery Temperature', 'Temperatura de Bateria'),
(171, 'Battery voltage', 'Voltaje de Bateria'),
(172, 'becquerels per gram', 'becquerels por gramo'),
(173, 'Benthic species', 'Especies bentónicas'),
(174, 'Benthos', 'Bentónicas'),
(175, 'Best Easy Systematic Estimator BES = (Q1 +2Q2 +Q3)/4.  Q1, Q2, and Q3 are first, second, and third quartiles. See Woodcock, F. and Engel, C., 2005: Operational Consensus Forecasts.Weather and Forecasting, 20, 101-111. (http://www.bom.gov.au/nmoc/bulletins/60/article_by_Woodcock_in_Weather_and_Forecasting.pdf) and Wonnacott, T. H., and R. J. Wonnacott, 1972: Introductory Statistics. Wiley, 510 pp.', 'Best Easy Systematic Estimator BES = (Q1 +2Q2 +Q3)/4.  Q1, Q2, y Q3 son el primer, segundo, y tercer cantiles. Ver Woodcock, F. and Engel, C., 2005: Operational Consensus Forecasts.Weather and Forecasting, 20, 101-111. (http://www.bom.gov.au/nmoc/bulletins/60/article_by_Woodcock_in_Weather_and_Forecasting.pdf) and Wonnacott, T. H., and R. J. Wonnacott, 1972: Introductory Statistics. Wiley, 510 pp.'),
(176, 'Bicarbonate', 'Bicarbonato'),
(177, 'Bicarbonate (HCO3-)', 'Bicarbonato (HCO3-)'),
(178, 'Bicarbonate Alkalinity ', 'Alcalinidad de bicarbonato '),
(179, 'billion colonies per day', 'billones colonias por day'),
(180, 'Biogenic silica', 'Sílice Biogénico'),
(181, 'Biomass, phytoplankton', 'Biomasa, Fitoplancton'),
(182, 'Biomass, total', 'Biomasa, Total'),
(183, 'Blue-green algae (cyanobacteria) with phycocyanin pigments', 'Las algas verdiazules (cianobacteria) con pigmentos ficocianina'),
(184, 'Blue-green algae (cyanobacteria), phycocyanin', 'Algas Verdiazules (Cianobacteria), Ficocianina'),
(185, 'BOD2, carbonaceous', 'BOD2, Carbonosa'),
(186, 'BOD20, carbonaceous', 'BOD20, Carbonosa'),
(187, 'BOD20, nitrogenous', 'BOD20, Nitrogenosa'),
(188, 'BOD3, carbonaceous', 'BOD3, Carbonosa'),
(189, 'BOD4, carbonaceous', 'BOD4, Carbonosa'),
(190, 'BOD5, carbonaceous', 'BOD5, Carbonosa'),
(191, 'BOD5, nitrogenous', 'BOD5, Nitrogenosa'),
(192, 'BOD6, carbonaceous', 'BOD6, Carbonosa'),
(193, 'BOD7, carbonaceous', 'BOD7, Carbonosa'),
(194, 'BODu, carbonaceous', 'BODu, Carbonosa'),
(195, 'BODu, nitrogenous', 'BODu, Nitrogenosa'),
(196, 'Body of land ice that consists of recrystallized snow accumulated on the surface of the ground and moves slowly downslope (WSP-1541A) over a period of years or centuries. Since glacial sites move, the lat-long precision for these sites is usually coarse.', 'Cuerpo de hielo terrestre que consiste en la nieve recristalizada acumulada en la superficie de la tierra y se mueve lentamente cuesta abajo (WSP-1541A) durante un período de años o siglos. Desde sitios glacial movimiento, el lat-larga de precisión de estos sitios suele ser grueso.'),
(197, 'Borehole log material classification', 'Clasificación de Material de Perforadora'),
(198, 'Boron', 'Boro'),
(199, 'Boron (B)', 'Boro (B)'),
(200, 'Borrichia frutescens Coverage', 'Cobertura de Borrichia frutescens'),
(201, 'boundaries', 'Frontera'),
(202, 'british thermal unit', 'unidades termicas británicas'),
(203, 'Bromide', 'Bromuro'),
(204, 'Bromine', 'Bromo'),
(205, 'Bromine (Br)', 'Bromo (Br)'),
(206, 'Bromine, dissolved', 'Bromo, Disuelto'),
(207, 'BTU per hour', 'BTU por hora'),
(208, 'Bulk electrical conductivity', 'Conductividad Eléctrica Grosor'),
(209, 'Bulk electrical conductivity of a medium measured using a sensor such as time domain reflectometry (TDR), as a raw sensor response in the measurement of a quantity like soil moisture.', 'Conductividad eléctrica en volumen de un medio medida usando un sensor tal como uno de tiempo de reflectometría en el dominio o time domain reflectometry (TDR), como una respuesta cruda del sensor en la medida de una cantidad como la humedad del suelo.'),
(210, 'Cadmium', 'Cadmio'),
(211, 'Cadmium (Cd)', 'Cadmio (Cd)'),
(212, 'Calcium ', 'Calcio '),
(213, 'Calcium (Ca) ', 'Calcio (Ca) '),
(214, 'Calcium, dissolved', 'Calcio, Disuelto'),
(215, 'Calibration Value', 'Valor de Calibración'),
(216, 'calorie', 'caloría'),
(217, 'calories per square centimeter per day', 'calorías por centimetro cuadrado por día'),
(218, 'calories per square centimeter per minute', 'calorías por square centimetro por minuto'),
(219, 'Carbon dioxide', 'Carbon Dióxido'),
(220, 'Carbon dioxide (CO2) flux', 'Flujo de Dióxido de Carbono(CO2)'),
(221, 'Carbon dioxide (CO2) storage flux', 'Flujo de Almacenamiento de Dióxido de Carbono(CO2)'),
(222, 'Carbon dioxide (CO2), raw data from sensor', 'Carbon dióxido (CO2), data cruda del sensor'),
(223, 'Carbon dioxide Flux', 'Carbon Dióxido Flujo'),
(224, 'Carbon dioxide Storage Flux', 'Carbon Dióxido Almacenamiento Flujo'),
(225, 'Carbon dioxide, transducer signal', 'Carbon Dióxido, Señal del Transductor'),
(226, 'Carbon disulfide', 'Carbon Disulfuro'),
(227, 'Carbon disulfide (CS2)', 'disulfuro de carbono (CS2)'),
(228, 'Carbon tetrachloride', 'Carbon Tetracloruro'),
(229, 'Carbon tetrachloride (CCl4)', 'tetracloruro de carbono (CCl4)'),
(230, 'Carbon to Nitrogen molar ratio', 'Carbon a Relación Nitrógeno Molar'),
(231, 'Carbon, dissolved inorganic', 'Carbon, Disuelto Inorgánico'),
(232, 'Carbon, dissolved organic', 'Carbon, Disuelto Orgánico'),
(233, 'Carbon, dissolved total', 'Carbon, Disuelto Total'),
(234, 'Carbon, particulate organic', 'Carbon, Partículado Orgánico'),
(235, 'Carbon, suspended inorganic', 'Carbon, Suspendido Inorgánico'),
(236, 'Carbon, suspended organic', 'Carbon, Suspendido Orgánico'),
(237, 'Carbon, suspened total', 'Carbon, Suspendido Total'),
(238, 'Carbon, total inorganic', 'Carbon, Total Inorgánico'),
(239, 'Carbon, total organic', 'Carbon, Total Orgánico'),
(240, 'Carbon, total solid phase', 'Carbon, Total Fase Sólida'),
(241, 'Carbonaceous Ultimate Biochemical Oxygen Demand', 'Demanda Ultima Carbonosa Bioquímica de Oxígeno'),
(242, 'Carbonate', 'Carbonato'),
(243, 'Carbonate Alkalinity ', 'Alcalinidad de carbonato '),
(244, 'Carbonate hardness also known as temporary hardness', 'Dureza de Carbonatos tambien conocida como dureza temporal'),
(245, 'Carbonate ion (CO3-2) concentration', 'Concentración de ion de Carbonato (CO3-2)'),
(246, 'Carlson Trophic State Index is a measurement of eutrophication based on Secchi depth', 'Indice de Estado Trofico de Carlson es una medida de eutroficazión basada en la profundidad del disco Secchi'),
(247, 'Categorical', 'Categórico'),
(248, 'Cave', 'Cueva'),
(249, 'cells per milliliter', 'celdas por mililitro'),
(250, 'cells per square millimeter', 'celdas por milimetro cuadrado'),
(251, 'cells/mm^2', 'celdas/mm^2'),
(252, 'centimeter   ', 'centimetro   '),
(253, 'centimeter of mercury', 'centimetro de mercurio'),
(254, 'centimeter of water', 'centimetro de agua'),
(255, 'centimeters per hour', 'centimetros por hour'),
(256, 'centimeters per second', 'centimetros por second'),
(257, 'Chemical oxygen demand', 'Demanda quimica de oxigeno'),
(258, 'Chloride', 'Cloruro'),
(259, 'Chloride (Cl-)', 'Cloruro (Cl-)'),
(260, 'Chloride, total', 'Cloruro, Total'),
(261, 'Chlorine', 'Cloro'),
(262, 'Chlorine (Cl)', 'Cloruro o Cloro (Cl)'),
(263, 'Chlorine, dissolved', 'Cloro, Disuelto'),
(264, 'Chlorophyll (a+b+c)', 'Clorofila (a+b+c)'),
(265, 'Chlorophyll a', 'Clorofila a'),
(266, 'Chlorophyll a allomer', 'Clorofila a Alomero'),
(267, 'Chlorophyll a uncorrected for pheophytin', 'Clorofila a sin corregir para feofitina'),
(268, 'Chlorophyll a, corrected for pheophytin', 'Clorofila a, corregida para feofitina'),
(269, 'Chlorophyll a, uncorrected for pheophytin', 'Clorofila a, sin corregir para feofitina'),
(270, 'Chlorophyll b', 'Clorofila b'),
(271, 'Chlorophyll c', 'Clorofila c'),
(272, 'Chlorophyll c1 and c2', 'Clorofila c1 y c2'),
(273, 'Chlorophyll Fluorescence', 'Clorofila Fluorescencia'),
(274, 'Chlorphyll a corrected for pheophytin', 'Clorofila a corregida para feofitina'),
(275, 'Chromium (III)', 'Cromo (III)'),
(276, 'Chromium (VI)', 'Cromo (VI)'),
(277, 'Chromium, all forms', 'Cromo, en todas sus formas'),
(278, 'Chromium, dissolved', 'Cromo, Disuelto'),
(279, 'Chromium, total', 'Cromo, Total'),
(280, 'Cistern', 'Cisterna'),
(281, 'Classification of material encountered by a driller at various depths during the drilling of a well and recorded in the borehole log.', 'Clasificación de material encontrado por una perforadora a varias profundidades durante la perforación de un pozo y registrada en el registro de pozo.'),
(282, 'Climate', 'Clima'),
(283, 'climatology/meteorology/atmosphere', 'climatologia/meteorologia/atmósfera'),
(284, 'Coastal', 'Costero'),
(285, 'Cobalt', 'Cobalto'),
(286, 'Cobalt (Co)', 'Cobalto (Co)'),
(287, 'Cobalt, dissolved', 'Cobalto, Disuelto'),
(288, 'Code for the agency which analyzed the sample', 'Código para la agencia que analizó la muestra'),
(289, 'Coliform, fecal', 'Coliforme, Fecal'),
(290, 'Coliform, total', 'Coliforme, Total'),
(291, 'Collector or drainage wells connected by an underground lateral.', 'Colector o drenaje pozos conectados por un lateral subterráneo.'),
(292, 'Collector or Ranney type well', 'Acumulador o Tipo de Pozo Ranney'),
(293, 'colonies per 100 milliliters', 'colonias por 100 mililitro'),
(294, 'colonies per gram', 'colonias por gramo');
INSERT INTO `spanish` (`ID`, `EngText`, `SpanishText`) VALUES
(295, 'colonies per milliliter', 'colonias por mililitro'),
(296, 'colonies/100 ml', 'colonias/100 ml'),
(297, 'colonies/g', 'colonias/g'),
(298, 'colonies/ml', 'colonias/ml'),
(299, 'colony forming units', 'colonia formantes unidades'),
(300, 'colony forming units per 100 milliliter', 'colonia formantes unidades por 100 mililitros'),
(301, 'colony forming units per milliliter', 'colonyiaformando unidades por mililitro'),
(302, 'Color in quantified in color units', 'Color en unidades de color cuantificadas'),
(303, 'Colored Dissolved Organic Matter', 'Materia Organica Coloreada Disuelto'),
(304, 'Combined sewer', 'Alcantarillado Combinado'),
(305, 'common year (365 days)', 'año comun (365 días)'),
(306, 'Concentration', 'Concentracion'),
(307, 'Concentration or organism concentration', 'Concentracion o Concentración de Organismos'),
(308, 'Concentration Ratio', 'Tasa de Concentracion'),
(309, 'Constant Over Interval', 'Constante durante Intervalo'),
(310, 'Container number', 'Número de Contenedor'),
(311, 'Continuous', 'Continuo'),
(312, 'Copper', 'Cobre'),
(313, 'Copper (Cu)', 'Cobre (Cu)'),
(314, 'Copper, dissolved', 'Cobre, Disuelto'),
(315, 'count', 'conteo'),
(316, 'count per half cubic foot', 'conteo por medo pies cubico'),
(317, 'counts per second', 'conteo por segundo'),
(318, 'Cryptophytes', 'Criptofitas'),
(319, 'cubic centimeter', 'centimetro cubico'),
(320, 'cubic centimeters per gram', 'centimetros cubicos por gramo'),
(321, 'cubic centimeters per second', 'centimetros cubicos por segundo'),
(322, 'cubic feet per barrel', 'pies cubicos por barril'),
(323, 'cubic feet per minute', 'cubic feet por minuto'),
(324, 'cubic feet per second', 'pies cubico por segundo'),
(325, 'cubic feet per second days', 'pies cubicos por segundo dias'),
(326, 'cubic foot', 'pies cubico'),
(327, 'cubic hecto meter', 'hecto metro cubico'),
(328, 'cubic meter', 'metros cubicos'),
(329, 'cubic meters per day', 'metros cubicos por día'),
(330, 'cubic meters per minute', 'metros cubicos por minuto'),
(331, 'cubic meters per second', 'metros cubicos por segundo'),
(332, 'Cumulative', 'Acumulativo'),
(333, 'Cuscuta spp. coverage', 'Cobertura de Cuscuta Spp.'),
(334, 'cysts per 10 liters', 'quistes por 10 litros'),
(335, 'cysts per 100 liters', 'quistes por 100 litros'),
(336, 'cysts/10 L', 'quistes/10 L'),
(337, 'cysts/100 L', 'quistes/100 L'),
(338, 'Data associated with agricultural production', 'Data asociada con la producción agricola'),
(339, 'Data associated with biological organisms', 'Datos asociados con organismos biológicos'),
(340, 'Data associated with boundaries', 'Data asociada con frontera'),
(341, 'Data associated with climatology, meteorology, or the atmosphere', 'Data asociada con climatologia, meteorologia, o la atmósfera'),
(342, 'Data associated with elevation', 'Data asociada con elevación'),
(343, 'Data associated with geology or geological processes', 'Datos asociados con la geología o los procesos geológicos'),
(344, 'Data associated with geoscientific information', 'Data asociada con información geo-cientifica'),
(345, 'Data associated with health', 'Data asociada con la salud'),
(346, 'Data associated with hydrologic variables or processes', 'Datos asociados con varibles o procesos hidrológicos'),
(347, 'Data associated with imagery, base maps, or earth cover', 'Data asociada con imagenes, mapas de base, o cobertura de la tierra'),
(348, 'Data associated with inland waters', 'Data asociada con aguas continentales o dentro de tierra'),
(349, 'Data associated with instrumentation and instrument properties such as battery voltages, data logger temperatures, often useful for diagnosis.', 'Datos asociados con instrumentación y propiedades de los instrumentos tales como voltaje de batería, temperaturas del data logger (registrador de datos), a menudo util para diagnóstco.'),
(350, 'Data associated with intelligence or the military', 'Data asociada con inteligencia o la milicia'),
(351, 'Data associated with location', 'Data asociada con localización'),
(352, 'Data associated with oceans', 'Data asociada con los océanos'),
(353, 'Data associated with planning or cadestre', 'Data asociada con planificación o catastro'),
(354, 'Data associated with society', 'Data asociada con la sociedad'),
(355, 'Data associated with structure', 'Data asociada con estructura'),
(356, 'Data associated with the climate, weather, or atmospheric processes', 'Datos asociados con el clima, el tiempo, o procesos atmosféricos'),
(357, 'Data associated with the economy', 'Data asociada con la economía'),
(358, 'Data associated with the environment', 'Data asociada con el medio ambiente'),
(359, 'Data associated with transportation', 'Data asociada con transportación'),
(360, 'Data associated with utilities or communication', 'Data asociada con servicios o comunicación'),
(361, 'Data associated with water quality variables or processes', 'Datos asociados con variables o procesos  de calidad de agua'),
(362, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 102 and 108 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 102 y 108 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(363, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 108 and 114 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 108 y 114 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(364, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 114 and 120 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 114 y 120 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(365, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 120 and 126 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 120 y 126 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(366, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 126 and 132 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 126 y 132 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(367, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 132 and 138 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 132 y 138 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(368, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 138 and 144 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 138 y 144 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(369, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 144 and 150 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 144 y 150 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(370, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 150 and 156 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 150 y 156 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(371, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 156 and 162 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 156 y 162 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(372, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 162 and 168 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG', 'Nombre del datum: datum geodésico Australiano 1984    Area de Uso: Australia - entre 162 y 168 grados Este.    Origen del datum: Fundamental point: Johnson Memorial Cairn. Latitud: 25 deg 56 min 54.5515 sec S; Longitud: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(373, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 102 and 108 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 102 y 108 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(374, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 108 and 114 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 108 y 114 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(375, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 114 and 120 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 114 y 120 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(376, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 120 and 126 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 120 y 126 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(377, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 126 and 132 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 126 y 132 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(378, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 132 and 138 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 132 y 138 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(379, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 138 and 144 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 138 y 144 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(380, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 144 and 150 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 144 y 150 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(381, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 150 and 156 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 150 y 156 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(382, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 156 and 162 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 156 y 162 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(383, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 162 and 168 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994    Area de Uso: Australia - entre 162 y 168 grados Este.    Origen del datum: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(384, 'Datum Name: Geocentric Datum of Australia 1994 Area of Use: Australia - New South Wales (NSW). Datum Origin: ITRF92 at epoch 1994.0  Ellipsoid Name: GRS 1980 Data Source: EPSG', 'Nombre del datum: Datum geocéntrico de Australia 1994 Area of Uso: Australia - New South Wales (NSW). Origen del datum: ITRF92 at epoch 1994.0  Ellipsoid Name: GRS 1980 Data Source: EPSG'),
(385, 'Datum Name: Mean Sea Level    Area of Use: World.    Datum Origin: No Data Available    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG', 'Nombre del datum: Nivel medio del mar    Area de Uso: World.    Datum Origin: No Data Available    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG'),
(386, 'Datum Name: World Geodetic System 1984    Area of Use: Between 102 and 108 deg East; southern hemisphere. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 102 y 108 grados Este; hemisferio Sur. Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(387, 'Datum Name: World Geodetic System 1984    Area of Use: Between 108 and 114 deg East; southern hemisphere. Australia. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 108 y 114 grados Este; hemisferio Sur. Australia. Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(388, 'Datum Name: World Geodetic System 1984    Area of Use: Between 114 and 120 deg East; southern hemisphere. Australia. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 114 y 120 grados Este; hemisferio Sur. Australia. Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(389, 'Datum Name: World Geodetic System 1984    Area of Use: Between 120 and 126 deg East; southern hemisphere. Australia. East Timor. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 120 y 126 grados Este; hemisferio Sur. Australia. East Timor. Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(390, 'Datum Name: World Geodetic System 1984    Area of Use: Between 126 and 132 deg East; southern hemisphere. Australia. East Timor. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 126 y 132 grados Este; hemisferio Sur. Australia. East Timor. Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(391, 'Datum Name: World Geodetic System 1984    Area of Use: Between 132 and 138 deg East; southern hemisphere. Australia.  Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 132 y 138 grados Este; shemisferio Sur. Australia.  Indonesia.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(392, 'Datum Name: World Geodetic System 1984    Area of Use: Between 138 and 144 deg East; southern hemisphere. Australia. Indonesia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 138 y 144 grados Este; hemisferio Sur. Australia. Indonesia. Papua New Guinea.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(393, 'Datum Name: World Geodetic System 1984    Area of Use: Between 144 and 150 deg East; southern hemisphere. Australia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 144 y 150 grados Este; hemisferio Sur. Australia. Papua New Guinea.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(394, 'Datum Name: World Geodetic System 1984    Area of Use: Between 150 and 156 deg East; southern hemisphere. Australia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 150 y 156 grados Este; hemisferio Sur. Australia. Papua New Guinea.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(395, 'Datum Name: World Geodetic System 1984    Area of Use: Between 156 and 162 deg East; southern hemisphere.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 156 y 162 grados Este; hemisferio Sur.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(396, 'Datum Name: World Geodetic System 1984    Area of Use: Between 162 and 168 deg East; southern hemisphere.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG', 'Nombre del datum: Sistema Geodésico Mundial 1984    Area de Uso: entre 162 y 168 grados Este; hemisferio Sur.    Origen del datum: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(397, 'day', 'día'),
(398, 'decibel', 'decibeles'),
(399, 'decisiemens per centimeter', 'decisiemens por centimetro'),
(400, 'decisiemens per meter', 'decisiemens por metro'),
(401, 'deg', 'grados'),
(402, 'degE', 'gradE'),
(403, 'degN', 'gradN'),
(404, 'degree', 'grado'),
(405, 'degree celsius', 'grados celsius'),
(406, 'degree Celsius millimoles per cubic meter', 'grados Celsius milimoles por cubico metro'),
(407, 'degree east', 'grados este'),
(408, 'degree fahrenheit', 'grados fahrenheit'),
(409, 'degree kelvin', 'grados kelvin'),
(410, 'degree north', 'grados norte'),
(411, 'degree rankine', 'grados rankine'),
(412, 'degree south', 'grados sur'),
(413, 'degree west', 'grados oeste'),
(414, 'degrees minutes seconds', 'grados minutos segundos'),
(415, 'degS', 'gradS'),
(416, 'degW', 'gradW'),
(417, 'Density', 'Densidad'),
(418, 'DEPRECATED -- The use of this term is discouraged in favor of the use of the synonymous term Carbon particulate organic.', 'DEPRECATED -- El uso de este término es desalentado en favor del uso del término sinónimo ''Carbono, partículas orgánicas''.'),
(419, 'Derived products', 'Productos Derivados'),
(420, 'Derived products that require scientific and technical interpretation and may include multiple-sensor data. An example is basin average precipitation derived from rain gages using an interpolation procedure.', 'Productos derivados que requieren interpretación científica y técnical y puede incluir datos de sensores múltiples. Un ejemplo de esto es la precipitación promediada sobre la cuenca derivada de los pluviometros usando un procedimiento de interpolación.'),
(421, 'Derived Value', 'Valor Derivado'),
(422, 'Deuterium', 'Deuterio'),
(423, 'Deuterium (2H), Delta D', 'Deuterio (2H), Delta D'),
(424, 'Dew point temperature', 'Temperatura de Punto de Rocío'),
(425, 'Difference in the  2H:1H ratio between the sample and standard', 'Diferencia en la tasa 2H:1H entre la muestra y el estandar'),
(426, 'Difference in the 15N:14N ratio between the sample and standard', 'Diferencia en la tasa 15N:14N entre la muestra y el estandar'),
(427, 'Difference in the 18O:16O ratio between the sample and standard', 'Diferencia en la tasa 18O:16O entre la muestra y el estandar'),
(428, 'Dimensionless', 'Adimensional'),
(429, 'Dinoflagellates', 'Dinoflagelados'),
(430, 'Direction of gusts of wind', 'Dirección de rafagas de viento'),
(431, 'Discharge', 'Caudal'),
(432, 'Dissolved Aluminum (Al)', 'Aluminio Disuelto (Al)'),
(433, 'Dissolved Barium (Ba)', 'Bario Disuelto (Ba)'),
(434, 'Dissolved Bromine (Br)', 'Bromo disuelto (Br)'),
(435, 'Dissolved Calcium (Ca)', 'Calcio Disuelto (Ca)'),
(436, 'Dissolved Chlorine (Cl)', 'Cloruro Disuelto (Cl)'),
(437, 'Dissolved Chromium', 'Cromo Disuelto'),
(438, 'Dissolved Cobalt (Co)', 'Cobalto Disuelto (Co)'),
(439, 'Dissolved Copper (Cu)', 'Cobre Disuelto (Cu)'),
(440, 'Dissolved Ethane (C2H6)', 'Etano Disuelto (C2H6)'),
(441, 'Dissolved Fluorine (Fl)', 'Flúor Disuelto (Fl)'),
(442, 'Dissolved Inorganic Carbon', 'Carbon Inorgánico Disuelto'),
(443, 'Dissolved inorganic nitrogen', 'Nitrogeno inorgánico disuelto '),
(444, 'Dissolved Iron (Fe)', 'Hierro Disueto (Fe)'),
(445, 'Dissolved Kjeldahl (organic nitrogen + ammonia (NH3) + ammonium (NH4))nitrogen', 'Kjeldahl disuelto(nitrogeno organico + amoniaco (NH3) + nitrogeno amonio (NH4))'),
(446, 'Dissolved Magnesium (Mg)', 'Magnesio disuelto (Mg)'),
(447, 'Dissolved Manganese (Mn)', 'Manganeso disuelto (Mn)'),
(448, 'Dissolved Methane (CH4)', 'Metano disuelto(CH4)'),
(449, 'Dissolved Nickel (Ni)', 'Níquel disuelto (Ni)'),
(450, 'Dissolved nitrate (NO3) nitrogen', 'Nitrato (NO3) nitrogeno disuelto '),
(451, 'Dissolved nitrite (NO2) + nitrate (NO3) nitrogen', 'nitrito (NO2) + nitrato (NO3) nitrogeno disuelto '),
(452, 'Dissolved nitrite (NO2) nitrogen', 'Nitrito NO2) nitrogeno disuelto '),
(453, 'Dissolved Organic Carbon', 'Carbon orgánico Disuelto'),
(454, 'Dissolved Organic Nitrogen', 'Nitrogeno Organico disuelto '),
(455, 'Dissolved organic phosphorus', 'Fosforo orgánico disuelto '),
(456, 'Dissolved orthophosphate phosphorus', 'Fósforo orthofosfatado disuelto'),
(457, 'Dissolved oxygen', 'Oxígeno disuelto'),
(458, 'Dissolved oxygen, percent saturation', 'Oxígeno disuelto, porcentaje de saturación'),
(459, 'Dissolved oxygen, raw data from sensor', 'oxigen disuelto, data cruda desde sensor'),
(460, 'Dissolved Phosphorus (P)', 'Fosforo disuelto(P)'),
(461, 'Dissolved Potassium (K)', 'Potasio Disuelto (K)'),
(462, 'Dissolved Silicon (Si)', 'Silicio disuelto (Si)'),
(463, 'Dissolved Sodium (Na)', 'Sodio (Na)disuelto'),
(464, 'Dissolved Strontium (Sr)', 'Estroncio (Sr)disuelto '),
(465, 'Dissolved Sulfate (SO4)', 'Sulfato(SO4) disuelto '),
(466, 'Dissolved Total (Organic+Inorganic) Carbon', 'Carbon Disuelto Total (Orgánico+Inorgánico)'),
(467, 'Dissolved Zinc (Zn)', 'Zinc (Zn) disuelto'),
(468, 'Dissolved Zircon (Zr)', 'Zirconio (Zr)disuelto '),
(469, 'Distance', 'Distancia'),
(470, 'Distance measured from a sensor to a target object such as the surface of a water body or snow surface.', 'Distancia medida desde un sensor a un objeto blanco tal como la suerficie de un cuerpo de agua o superficie de nieve.'),
(471, 'Distichlis spicata Coverage', 'Cobertura de Distichlis spicata'),
(472, 'Ditch', 'Cuneta'),
(473, 'Diversion', 'Desviación'),
(474, 'Drag or trangential force per unit area exerted on a surface by the adjacent layer of moving air', 'Arrastre o fuerza tangencial por unidad de area ejercida sobre una superficie por la capa adyacente de aire en movimiento'),
(475, 'drips per minute', 'drips por minuto'),
(476, 'dyne', 'dina'),
(477, 'economy', 'economía'),
(478, 'Electric Energy', 'Energía Eléctrica'),
(479, 'Electric Power', 'Potencia Eléctrica'),
(480, 'Electrical Conductivity', 'Conductividad Electrica'),
(481, 'elevation', 'elevación'),
(482, 'Energy', 'Energia'),
(483, 'Energy Flux', 'Flujo de Energía'),
(484, 'Energy per Area', 'Energía por Area'),
(485, 'Enterococcal bacteria', 'Bacterias enterococos'),
(486, 'Enterococci', 'enterococos'),
(487, 'environment', 'ambiente'),
(488, 'Escherichia coli', 'Escherichi coli'),
(489, 'Estuary', 'Estuario'),
(490, 'Ethane, dissolved', 'Etano, Disuelto'),
(491, 'Evaporation', 'Evaporación'),
(492, 'Evapotranspiration', 'Evapotranspiración'),
(493, 'Evapotranspiration, potential', 'Evapotranspiración, Potential'),
(494, 'Excavation', 'Excavación'),
(495, 'Expressed as aluminium', 'Expresado como aluminio'),
(496, 'Expressed as ammonium', 'Expresado como amonio'),
(497, 'Expressed as antimony', 'Expresado como antimonio'),
(498, 'Expressed as arsenic', 'Expresado como arsénico'),
(499, 'Expressed as barium', 'Expresado como bario'),
(500, 'Expressed as boron', 'Expresado como boro'),
(501, 'Expressed as bromine', 'Expresado como bromo'),
(502, 'Expressed as cadmium', 'Expresado como cadmio'),
(503, 'Expressed as calcium', 'Expresado como calcio'),
(504, 'Expressed as calcium carbonate', 'Expresado como carbonato de calcio'),
(505, 'Expressed as carbon', 'Expresado como carbon'),
(506, 'Expressed as carbon dioxide', 'Expresado como dioxido de carbon'),
(507, 'Expressed as carbonate', 'Expresado como carbonato'),
(508, 'Expressed as chlorine', 'Expresado como cloro'),
(509, 'Expressed as chromium', 'Expresado como cromo'),
(510, 'Expressed as cobalt', 'Expresado como cobalto'),
(511, 'Expressed as copper', 'Expresado como cobre'),
(512, 'Expressed as deuterium', 'Expresado como deuterio'),
(513, 'Expressed as electrical conductivity', 'Expresado como conductividad electrica'),
(514, 'Expressed as ethane', 'Expresado como etano'),
(515, 'Expressed as fluorine ', 'Expresado como fluor'),
(516, 'Expressed as hydrogen carbonate', 'Expresado como carbonato de hidrogeno'),
(517, 'Expressed as iron', 'Expresado como hierro'),
(518, 'Expressed as lead', 'Expresado como plomo'),
(519, 'Expressed as magnesium', 'Expresado como magnesio'),
(520, 'Expressed as manganese', 'Expresado como manganeso'),
(521, 'Expressed as mercury', 'Expresado como mercurio'),
(522, 'Expressed as methane', 'Expresado como metano'),
(523, 'Expressed as molybdenum', 'Expresado como molibdeno'),
(524, 'Expressed as nickel', 'Expresado como niquel'),
(525, 'Expressed as nitrate', 'Expresado como nitrato'),
(526, 'Expressed as nitrite', 'Expresado como nitrito'),
(527, 'Expressed as nitrogen', 'Expresado como nitrogeno'),
(528, 'Expressed as nitrogen-15', 'Expresado como nitrogeno-15'),
(529, 'Expressed as oxygen-18', 'Expresado como oxigeno-18'),
(530, 'Expressed as pH', 'Expresado como pH'),
(531, 'Expressed as phosphate', 'Expresado como fosfato'),
(532, 'Expressed as phosphorus', 'Expresado como fosforo'),
(533, 'Expressed as potassium', 'Expresado como potasio'),
(534, 'Expressed as selenium', 'Expresado como selenio'),
(535, 'Expressed as silicate', 'Expresado como silicato'),
(536, 'Expressed as silicon', 'Expresado como silicio'),
(537, 'Expressed as sodium', 'Expresado como sodio'),
(538, 'Expressed as strontium', 'Expresado como estroncio'),
(539, 'Expressed as Sulfate', 'Expresado como Sulfato'),
(540, 'Expressed as Sulfur', 'Expresado como Sulfuro'),
(541, 'Expressed as thallium', 'Expresado como talio'),
(542, 'Expressed as tin', 'Expresado como estaño'),
(543, 'Expressed as titanium', 'Expresado como titanio'),
(544, 'Expressed as total alkalinity', 'Expresado como alacalinidad total'),
(545, 'Expressed as uranium', 'Expresado como uranio'),
(546, 'Expressed as vanadium', 'Expresado como vanadio'),
(547, 'Expressed as water', 'Expresado como agua'),
(548, 'Expressed as zinc', 'Expresado como zinc'),
(549, 'Expressed as zircon', 'Expresado como zirconio'),
(550, 'Extensometer well', 'Pozo de Extensómetro'),
(551, 'Extinction/Absorbance', 'Extincción/Absorbancia'),
(552, 'Facility', 'Facilidad'),
(553, 'farming', 'agricola'),
(554, 'Fecal Coliform', 'Coliforme fecal'),
(555, 'Fecal Streptococci', 'estreptococos fecales'),
(556, 'feet per second', 'pies por second'),
(557, 'Ferric Iron (Fe+3)', 'Hierro Férrico (Fe+3)'),
(558, 'Ferrous Iron (Fe+2)', 'Hierro Ferroso (Fe+2)'),
(559, 'fibers per liter', 'fibras por litro'),
(560, 'Field Observation', 'Observación de Campo'),
(561, 'Field, Pasture, Orchard, or Nursery', 'Campo, Pasto, Huerta, o Vivero'),
(562, 'Fish detections', 'Detecciones de Pescado'),
(563, 'Fixed Dissolved Solids', 'Solidos Fijos disueltos'),
(564, 'Fixed Suspended Solids', 'Solidos Fijos Suspendidos'),
(565, 'Flash memory error count', 'Número de Errores de Memoria Flash'),
(566, 'Flow', 'Flujo'),
(567, 'Flow rate from well while pumping', 'Tasa de flujo de un pozo mientras esta bombeando'),
(568, 'Flowback water', 'Agua de Flowback'),
(569, 'Fluids produced from wells during oil or gas production which may include formation water, injected fluids, oil and gas.', 'Fluidos producidos desde pozos durante producción de oil o gas que puede incluir agua de formación, los fluidos inyectados, petróleo y gas.'),
(570, 'Fluorescence', 'Fluorescencia'),
(571, 'Fluoride', 'Fluoruro'),
(572, 'Fluoride - F-', 'Flúor - F-'),
(573, 'Fluorine', 'Flúor'),
(574, 'Fluorine (F-)', 'Flúor (F-)'),
(575, 'Fluorine, dissolved', 'Flúor, Disuelto'),
(576, 'foot candle', 'pies velas'),
(577, 'foot pound force', 'fuerza pie libra'),
(578, 'foot pound force per second', 'pie libra de fuerza por segundo'),
(579, 'Force', 'Fuerza'),
(580, 'formazin attenuation unit', 'formazin atenuación unidad'),
(581, 'formazin backscatter unit ', 'formazin backscatter unidad '),
(582, 'formazin nephelometric multibeam unit', 'formazin nefelometrica multirayo unidad'),
(583, 'formazin nephelometric ratio unit', 'formazin nefelometrica tasa unidad'),
(584, 'formazin nephelometric unit', 'formazin nefelometrica unidad'),
(585, 'Free Ammonia (NH3)', 'Amoniaco libre (NH3)'),
(586, 'Frequency', 'Frecuencia'),
(587, 'Friction velocity', 'Velocidad de Fricción'),
(588, 'Gage height', 'Altura Galga'),
(589, 'gallons per batch', 'galones por batch'),
(590, 'gallons per day', 'galones por día'),
(591, 'gallons per day per square foot', 'galones por day por pie cuadrado'),
(592, 'gallons per hour', 'galones por hora'),
(593, 'gallons per minute', 'galones por minuto'),
(594, 'gallons per second', 'galones por segundo'),
(595, 'Gaseous Nitrogen (N2)', 'Nitrogeno gasesoso (N2)'),
(596, 'Geology', 'Geología'),
(597, 'geoscientificInformation', 'geo-cientificaInformación'),
(598, 'Glacier', 'Glaciar'),
(599, 'Global Radiation', 'Radiación Global'),
(600, 'Golf course', 'Campo de Golf'),
(601, 'Grab sample', 'Agarrar muestra'),
(602, 'grad', 'grados'),
(603, 'grain', 'grano'),
(604, 'grains per gallon', 'granos por gallon'),
(605, 'gram', 'gramo'),
(606, 'grams per cubic centimeter', 'grams por centimetro cubico'),
(607, 'grams per cubic meter per hour', 'grams por cubic metros por hour'),
(608, 'grams per day', 'gramos por day'),
(609, 'grams per kilogram', 'gramos por kilogramo'),
(610, 'grams per liter', 'gramos por litro'),
(611, 'grams per minute', 'grams por minuto'),
(612, 'grams per second', 'grams por segundo'),
(613, 'grams per square meter', 'gramos por metro cuadrado'),
(614, 'grams per square meter per day', 'gramos por metro cuadrado por día'),
(615, 'grams per square meter per hour', 'gramos por metro cuadrado por hora'),
(616, 'greg yr', 'año greg'),
(617, 'Gregorian year (365.2425 days)', 'año Gregoriano (365.2425 días)'),
(618, 'Ground heat flux', 'Calor del Suelo Flujo'),
(619, 'Groundwater', 'Aguas Subterráneas'),
(620, 'Groundwater Depth', 'Agua Subterranea Profundidad'),
(621, 'Groundwater depth is the distance between the water surface and the ground surface at a specific location specified by the site location and offset.', 'Profundidad de agua subterranea es la distancia entre la superficie del agua y la superficie del terreno en una localización especifica especificada por la localización del sitio y el offset.'),
(622, 'Groundwater drain', 'Drenaje de Aguas Subterráneas'),
(623, 'Hardness, carbonate', 'Dureza, Carbonatos'),
(624, 'Hardness, non-carbonate', 'Dureza, No-Carbonatos'),
(625, 'Hardness, total', 'Dureza, Total'),
(626, 'health', 'salud'),
(627, 'Heat index', 'Índice de Calor'),
(628, 'hectare', 'hectarea'),
(629, 'hectare meter', 'hectarea metro'),
(630, 'Hexavalent Chromium', 'Cromo Hexavalente'),
(631, 'hits per square centimeter', 'hits por centimetros cuadrados'),
(632, 'hits per square centimeter per hour', 'hits por centimetro cuadradopor hora'),
(633, 'horse power (shaft)', 'caballo de potencia (shaft)'),
(634, 'hour', 'hora'),
(635, 'hour minute', 'hora minuto'),
(636, 'Hydrated silica (SiO2 nH20)', 'sílice hidratada (SiO2 nH20)'),
(637, 'Hydrated silica disolved in water', 'Silice hidrata disuelta en agua'),
(638, 'Hydroelectric plant', 'Planta Hidroeléctrica'),
(639, 'Hydrogen sulfide', 'Hidrógeno Sulfuro'),
(640, 'Hydrogen sulfide (H2S)', 'Sulfuro de Hidrogeno (H2S)'),
(641, 'Hydrogen-2, stable isotope ratio delta', 'Hidrógeno-2, Estable Relación Isotópica Delta'),
(642, 'Hydrology', 'Hidrología'),
(643, 'Hydroxide Alkalinity ', 'Alcalinidad de hidroxido'),
(644, 'Hyporheic-zone well', 'Pozo de Hyporheic-zona'),
(645, 'Illuminance', 'Iluminancia'),
(646, 'imageryBaseMapsEarthCover', 'imagenesMapasdeBaseCoberturadelaTierra'),
(647, 'Imaginary dielectric constant', 'Imaginario Constante Dieléctrica'),
(648, 'inch H2O', 'pulg H2O'),
(649, 'inch Hg', 'pulg Hg'),
(650, 'inch of mercury', 'pulgada de mercurio'),
(651, 'inch of water', 'pulgada de agua'),
(652, 'inches per day', 'pulgadas por dia'),
(653, 'inches per hour', 'pulgadas por hora'),
(654, 'inches per storm', 'pulgadas por tormenta'),
(655, 'inches per week', 'pulgadas por semana'),
(656, 'Incoming Longwave Radiation', 'Radiación Entrante de onda larga'),
(657, 'Incoming Photosynthetically-Active Radiation', 'Radiación Entrante Fotosintheticamente-Activa'),
(658, 'Incoming Shortwave Radiation', 'Radiación Entrante de onda corta'),
(659, 'Incoming Ultraviolet A Radiation', 'Radiación Entrante Ultravioleta A'),
(660, 'Incoming Ultraviolet B Radiation', 'Radiacion Entrante Ultravioleta B'),
(661, 'inlandWaters', 'aguasContinentales'),
(662, 'Inorganic Phosphorus', 'Fosforo Inorgánico'),
(663, 'Instrumentation', 'Instrumentación'),
(664, 'intelligenceMilitary', 'inteligenciadeMilicia'),
(665, 'Interconnected wells', 'Pozos Interconectados'),
(666, 'international foot', 'pie internacional'),
(667, 'international inch', 'pulgada internacional'),
(668, 'international mile', 'milla internacional'),
(669, 'international yard', 'yarda internacional'),
(670, 'Interpreted products', 'Productos Interpretados'),
(671, 'Interpreted products that require researcher driven analysis and interpretation, model-based interpretation using other data and/or strong prior assumptions. An example is basin average precipitation derived from the combination of rain gages and radar return data.', 'Productos interpretados que requieren un analisis e interpretación conducido por un investigador, interpretación basada en modelos usando otros datos y/o fuertes supuestos previos. Un ejemplo de esto es la precipitación media de la cuenca  derivada de la combinación de pluviómetros y data retornada de radares.'),
(672, 'Iron sulfide', 'Hierro Sulfuro'),
(673, 'Iron sulfide (FeS2)', 'Sulfuro e Hierro (FeS2)'),
(674, 'Iron, dissolved', 'Hierro, Disuelto'),
(675, 'Iron, ferric', 'Hierro, Férrico'),
(676, 'Iron, ferrous', 'Hierro, Ferroso'),
(677, 'Iva frutescens coverage', 'Cobertura de Iva frutescens'),
(678, 'jackson candle units ', 'jackson unidades de velas'),
(679, 'jackson turbidity units', 'jackson turbidez unidades'),
(680, 'Joules per square centimeter', 'Joules por centimetro cuadrado'),
(681, 'jul yr', 'año jul'),
(682, 'Julian year (365.25 days)', 'año Juliano (365.25 días)'),
(683, 'kg/month', 'kg/mes'),
(684, 'kilo grams per cubic meter', 'kilogramos por metro cubico'),
(685, 'kilo grams per month', 'kilogramos por mes'),
(686, 'kilo pound force', 'kilo libra de fuerza'),
(687, 'kilogram', 'kilogramo'),
(688, 'kilogram force', 'kilogramo de fuerza'),
(689, 'kilograms per hectare per day', 'kilogramos por hectarea por dia'),
(690, 'kilograms per square meter', 'kilogramos por metro cuadrado'),
(691, 'kilometer', 'kilometro'),
(692, 'kilometers per hour', 'kilometros por hora'),
(693, 'kilowatt hour', 'kilowatt hora'),
(694, 'kilowatts per square meter', 'kilowatts por metro cuadrado'),
(695, 'knot', 'nudos'),
(696, 'Knowledge products', 'Productos de Conocimiento'),
(697, 'Knowledge products that require researcher driven scientific interpretation and multidisciplinary data integration and include model-based interpretation using other data and/or strong prior assumptions. An example is percentages of old or new water in a hydrograph inferred from an isotope analysis.', 'Productos de Conocimiento que requiere interpretacion cientifica conducidad por un investigador y la integración multidisciplinaria de data e incluye interpretación basa en modelos usando otros datos y/o fuertes supuestos previos. Un ejemplo de esto es el porcentaje de agua vieja o nueva en un hidrograma inferido de un análisis de isotopos.'),
(698, 'Laboratory or sample-preparation area', 'Laboratorio o Área de Preparación de Muestra'),
(699, 'Lake, Reservoir, Impoundment', 'Lago o Embalse'),
(700, 'Land', 'Tierra'),
(701, 'Land where saturation with water is the dominant factor determining the nature of soil development and the types of plant and animal communities living in the soil and on its surface (Cowardin, December 1979). Wetlands are found from the tundra to the tropics and on every continent except Antarctica. Wetlands are areas that are inundated or saturated by surface or groundwater at a frequency and duration sufficient to support, and that under normal circumstances do support, a prevalence of vegetation typically adapted for life in saturated soil conditions. Wetlands generally include swamps, marshes, bogs and similar areas. Wetlands may be forested or unforested, and naturally or artificially created.', 'Tierra donde la saturación de agua es el factor dominante en la determinación de la naturaleza del desarrollo del suelo y los tipos de comunidades vegetales y animales que viven en el suelo y en su superficie (Cowardin, diciembre de 1979). Los humedales se encuentran desde la tundra hasta los trópicos y en todos los continentes excepto la Antártida. Los humedales son áreas que están inundadas o saturadas por agua superficial o subterránea en una frecuencia y duración suficientes para apoyar, y que en circunstancias normales lo hacen de soporte, una prevalencia de vegetación típicamente adaptada a la vida en condiciones de saturación del suelo. Los humedales generalmente incluyen pantanos, ciénagas, pantanos y áreas similares. Los humedales pueden ser forestadas o deforestadas, y crearon natural o artificialmente.'),
(702, 'Landfill', 'Relleno Sanitario'),
(703, 'Langelier Saturation Index is an indicator of the degree of saturation of water with respect to calcium carbonate ', 'El Indice de Saturación de Langelier es un indicador del grado de saturación del agua con respecto al carbonato de calcio'),
(704, 'langleys per day', 'langleys por día'),
(705, 'Langleys per hour', 'Langleys por hora'),
(706, 'langleys per minute', 'langleys por minuto'),
(707, 'langleys per second', 'langleys por segundo'),
(708, 'Latent Heat Flux', 'Flujo de Calor Latente'),
(709, 'Latitude', 'Latitud'),
(710, 'Latitude as a variable measurement or observation (Spatial reference to be designated in methods). ', 'Latitud como una medida de variable u observación (referencia espacial a ser designada en metodos). '),
(711, 'Lead', 'Plomo'),
(712, 'Lead (Pb)', 'Plomo (Pb)'),
(713, 'Leaf wetness', 'Humedad de Hoja'),
(714, 'leap year (366 days)', 'año bisiesto (366 días)'),
(715, 'leap yr', 'año bis'),
(716, 'Length', 'Longitud'),
(717, 'Light', 'Luz');
INSERT INTO `spanish` (`ID`, `EngText`, `SpanishText`) VALUES
(718, 'Light attenuation coefficient', 'Coeficiente de Atenuación de Luz'),
(719, 'Light Extinction', 'Extincción de Luz'),
(720, 'Light Intensity', 'Intensidad de Luz'),
(721, 'Limonium nashii Coverage', 'Cobertura de Limonium Nashii'),
(722, 'liter', 'litro'),
(723, 'liters per day', 'litros por dia'),
(724, 'liters per hour', 'litros por hora'),
(725, 'liters per minute', 'litros por minuto'),
(726, 'liters per second', 'litros por segundo'),
(727, 'Lithium', 'Litio'),
(728, 'Lithium (Li)', 'Litio (Li)'),
(729, 'Loading', 'Carga'),
(730, 'location', 'localización'),
(731, 'Longitude', 'Longitud'),
(732, 'Longitude as a variable measurement or observation (Spatial reference to be designated in methods). This is distinct from the longitude of a site which is a site attribute.', 'Longitud como una medida de variable u observación (referencia espacial a ser designada en metodos. Esto es distinto a la longitud de un sitio la cual which es un atributo del sitio.'),
(733, 'Low battery count', 'Recuento Bajo de Batería'),
(734, 'lumens per square foot', 'lumens por pie cuadrado'),
(735, 'Lycium carolinianum Coverage', 'Cobertura de Lycium Carolinianum'),
(736, 'Magnesium', 'Magnesio'),
(737, 'Magnesium (Mg)', 'Magnesio (Mg)'),
(738, 'Magnesium, dissolved', 'Magnesio, Disuelto'),
(739, 'Manganese', 'Manganeso'),
(740, 'Manganese (Mn)', 'Manganeso (Mn)'),
(741, 'Manganese, dissolved', 'Manganeso, Disuelto'),
(742, 'Mass', 'Masa'),
(743, 'Mass flow per unit width', 'Flujo de Masa por unidad de ancho'),
(744, 'Mass Fraction', 'Masa Fracción'),
(745, 'Maximum', 'Máximo'),
(746, 'Measurement of phytoplankton with no differentiation between species', 'Medida de fitoplancton sin diferentiación entre especies'),
(747, 'megajoules per square meter', 'megajoules por metro cuadradado'),
(748, 'megajoules per square meter per day', 'megajoules por square metro por día'),
(749, 'megaliter', 'megalitro'),
(750, 'Mercury', 'Mercurio'),
(751, 'Mercury (Hg)', 'Mercurio (Hg)'),
(752, 'meter', 'metro'),
(753, 'meters per day', 'metros por day'),
(754, 'meters per hour', 'metros per hora'),
(755, 'meters per meter', 'meters por meter'),
(756, 'meters per pixel', 'metros por pixel'),
(757, 'meters per second', 'metros por segundo'),
(758, 'meters per second degree Celsius', 'metros per segundo grados Celsius'),
(759, 'meters squared per second squared', 'metros squared por segundo cuadrado'),
(760, 'Methane, dissolved', 'Metano, Disuelto'),
(761, 'Methylmercury', 'Methylmercurio'),
(762, 'Methylmercury (CH3Hg)', 'Methylmercurio (CH3Hg)'),
(763, 'metric ton', 'tonelada metrica'),
(764, 'microeinsteins per square meter', 'microeinsteins por metro cuadrado'),
(765, 'microeinsteins per square meter per day', 'microeinsteins por metro cuadrado por dia'),
(766, 'microeinsteins per square meter per second', 'microeinsteins por square metro por segundo'),
(767, 'microequivalents per liter', 'microequivalentes por litro'),
(768, 'microgram', 'microgramo'),
(769, 'microgram per milliliter', 'microgramo por mililitro'),
(770, 'micrograms per cubic meter', 'microgramos por cubic meter'),
(771, 'micrograms per kilogram', 'microgramos por kilogramo'),
(772, 'micrograms per liter', 'microgramos por litro'),
(773, 'micrograms per square meter', 'microgramos por metro cuadrado'),
(774, 'micromoles per liter', 'micromoles por litro'),
(775, 'micromoles per liter per hour', 'micromoles por litro por hora'),
(776, 'micromoles per square meter per second', 'micromoles por metro cuadrado por segundo'),
(777, 'micron', 'micrón'),
(778, 'microsiemens per centimeter', 'microsiemens por centimetro'),
(779, 'miles per hour', 'millas por hora'),
(780, 'millibar', 'milibar'),
(781, 'milliequivalents', 'miliequivalentes'),
(782, 'milliequivalents per 100 gram', 'milliequivalentes por 100 gram'),
(783, 'milliequivalents per liter', 'milliequivalentes por litro'),
(784, 'milligram', 'miligramo'),
(785, 'milligrams per cubic meter', 'miligramos por metro cubico'),
(786, 'milligrams per cubic meter per day', 'miligramos por metro cubico por día'),
(787, 'milligrams per cubic meter per hour', 'milligramos por metro cubico por hora'),
(788, 'milligrams per cubic meter squared', 'miligramos por metro cubico'),
(789, 'milligrams per day', 'milligramos por dia'),
(790, 'milligrams per kilogram', 'miligramos por kilogramo'),
(791, 'milligrams per liter', 'milligramos por litro'),
(792, 'milligrams per square meter', 'miligramos por metro cuadrado'),
(793, 'milligrams per square meter per day', 'miligramos por meter cuadrado por día'),
(794, 'milliliter', 'mililitro'),
(795, 'milliliters per square centimeter per day', 'mililitros por square centimetro por día'),
(796, 'millimeter', 'milimetro'),
(797, 'millimeter of mercury', 'milimetro de mercurio'),
(798, 'millimeter of water', 'milimetro de agua'),
(799, 'millimeters per day', 'milimetros por dia'),
(800, 'millimeters per hour', 'millimetros por hora'),
(801, 'millimeters per second', 'milimetros por segundo'),
(802, 'millimoles of photons per square meter', 'milimoles de fotones por metro cuadrado'),
(803, 'millimoles per cubic meter', 'milimoles por cubic meter'),
(804, 'millimoles per cubic meter squared', 'milimoles por cubic meter squared'),
(805, 'millimoles per kilogram', 'millimoles por kilogramo'),
(806, 'millimoles per square meter per hour', 'millimoles por metro cuadrado por hora'),
(807, 'millimoles per square meter per second', 'milimoles por metro cuadrado por segundo'),
(808, 'million cubic feet', 'millones cubic feet'),
(809, 'million gallons', 'millones galones'),
(810, 'million gallons per day', 'millones galones por día'),
(811, 'million gallons per month', 'millones de galones por mes'),
(812, 'million gallons per year', 'millones de galones por año'),
(813, 'milliosmols per kilogram', 'milliosmoles por kilogramo'),
(814, 'millisecond', 'milisegundo'),
(815, 'millisiemens per centimeter', 'milisiemens por centimetro'),
(816, 'Minimum', 'Mínimo'),
(817, 'minute', 'minuto'),
(818, 'mm/day', 'mm/dia'),
(819, 'Mode', 'Moda'),
(820, 'Model Simulation Result', 'Resultado de Simulación del Modelo'),
(821, 'mols per cubic meter', 'moles por metro cubico'),
(822, 'Molybdenum', 'Molibdeno'),
(823, 'Molybdenum (Mo)', 'Molibdeno (Mo)'),
(824, 'Momentum flux', 'Flujo de Momentum'),
(825, 'Monanthochloe littoralis Coverage', 'Cobertura de Monanthochloe Littoralis'),
(826, 'month', 'mes'),
(827, 'month year', 'mes año'),
(828, 'most probable number', 'número mas probable'),
(829, 'most probable number per 100 liters', 'número mas probable por 100 litros'),
(830, 'most probable number per 100 milliliters', 'número mas probable por 100 mililitros'),
(831, 'most probable number per gram', 'número mas probable por gramo'),
(832, 'Multiple wells', 'Varios Pozos'),
(833, 'Municipal waste water', 'Aguas Residuales Municipales'),
(834, 'N, albuminoid', 'N, Albuminoide'),
(835, 'nanograms per cubic meter', 'nanogramos por metro cubico'),
(836, 'nanograms per liter', 'nanogramos por litro'),
(837, 'nanograms per square meter per hour', 'nanogramos por metro cuadrado por hora'),
(838, 'nanograms per square meter per week', 'nanogramos por metro cuadrado por semana'),
(839, 'nanomoles per kilogram', 'nanomoles por kilogramo'),
(840, 'nanomoles per liter', 'nanomoles per litro'),
(841, 'National Geodetic Vertical Datum of 1929', 'Datum Vertical Nacional Geodésico del 1929'),
(842, 'nautical mile', 'milla nautica'),
(843, 'nautical mile per hour', 'milla nautica por hora'),
(844, 'nephelometric turbidity multibeam unit', 'nefelometrico turbidez multirayo unidad'),
(845, 'nephelometric turbidity ratio unit', 'nefelometrico turbidez tasa unidad'),
(846, 'nephelometric turbidity units', 'nefelometrico turbidez unidades'),
(847, 'Net heat flux', 'Flujo de Calor Neto'),
(848, 'Net Longwave Radiation', 'Radiación Neta de Onda Larga'),
(849, 'Net Neutralization Potential', 'Net Neutralizacion Potencial'),
(850, 'Net Photosynthetically-Active Radiation', 'Radiación Neta Fotosinteticamente-Activa'),
(851, 'Net Radiation', 'Radiación Neta'),
(852, 'Net respiration', 'Respiración Neta'),
(853, 'Net Shortwave radiation', 'Radiación Neta de Onda Corta'),
(854, 'Newton per square meter', 'Newton por metro cuadrado'),
(855, 'Nickel', 'Níquel'),
(856, 'Nickel (Ni)', 'Níquel (Ni)'),
(857, 'Nickel, dissolved', 'Níquel, Disuelto'),
(858, 'Nitrate (NO3) Nitrogen', 'Nitrato (NO3) Nitrogeno'),
(859, 'Nitrite (NO2) + Nitrate (NO3) Nitrogen', 'Nitrito (NO2) + Nitrato (NO3) Nitrogeno'),
(860, 'Nitrite (NO2) Nitrogen', 'Nitrito (NO2) Nitrogeno'),
(861, 'Nitrogen, Dissolved Inorganic', 'Nitrógeno, Disuelto Inorgánico'),
(862, 'Nitrogen, dissolved Kjeldahl', 'Nitrógeno, Disuelto Kjeldahl'),
(863, 'Nitrogen, dissolved nitrate (NO3)', 'Nitrógeno, Disuelto Nitrato (NO3)'),
(864, 'Nitrogen, dissolved nitrite (NO2)', 'Nitrógeno, Disuelto Nitrito (NO2)'),
(865, 'Nitrogen, dissolved nitrite (NO2) + nitrate (NO3)', 'Nitrógeno, Disuelto Nitrito (NO2) + Nitrato (NO3)'),
(866, 'Nitrogen, Dissolved Organic', 'Nitrógeno, Disuelto Orgánico'),
(867, 'Nitrogen, gas', 'Nitrógeno, gas'),
(868, 'Nitrogen, inorganic', 'Nitrógeno, Inorgánico'),
(869, 'Nitrogen, NH3', 'Nitrógeno, NH3'),
(870, 'Nitrogen, NH3 + NH4', 'Nitrógeno, NH3 + NH4'),
(871, 'Nitrogen, NH4', 'Nitrógeno, NH4'),
(872, 'Nitrogen, nitrate (NO3)', 'Nitrógeno, Nitrato (NO3)'),
(873, 'Nitrogen, nitrite (NO2)', 'Nitrógeno, Nitrito (NO2)'),
(874, 'Nitrogen, nitrite (NO2) + nitrate (NO3)', 'Nitrógeno, Nitrito (NO2) + Nitrato (NO3)'),
(875, 'Nitrogen, organic', 'Nitrógeno, Orgánico'),
(876, 'Nitrogen, organic kjeldahl', 'Nitrógeno, Orgánico kjeldahl'),
(877, 'Nitrogen, particulate organic', 'Nitrógeno, Particulado Orgánico'),
(878, 'Nitrogen, total', 'Nitrógeno, Total'),
(879, 'Nitrogen, total dissolved', 'Nitrógeno, Total Disuelto'),
(880, 'Nitrogen, total kjeldahl', 'Nitrógeno, Total Jjeldahl'),
(881, 'Nitrogen, total organic', 'Nitrógeno, Total Orgánico'),
(882, 'Nitrogen-15', 'Nitrógeno-15'),
(883, 'Nitrogen-15, stable isotope ratio delta', 'Nitrógeno-15, Estable Relación Isotópica Delta'),
(884, 'Nitrogenous Ultimate Biochemical Oxygen Demand', 'Demanda Ultima Nitrogenosa Bioquímica de Oxígeno'),
(885, 'No method specified', 'Ningún Método Especificado'),
(886, 'No vegetation coverage', 'Sin Cobertura de Vegetación'),
(887, 'Non-carbonate hardness', 'Dureza No-carbonatada'),
(888, 'Normality', 'Normalidad'),
(889, 'North American Vertical Datum of 1988', 'Datum Vertical de Norte America del 1988'),
(890, 'Not Applicable', 'No Aplicable'),
(891, 'Not Relevant', 'No Relevante'),
(892, 'number of organisms per 100 gallon', 'numero de organismos por 100 galones'),
(893, 'number of organisms per 100 milliliter', 'numero de organisms per 100 mililitro'),
(894, 'number of organisms per 500 milliliter', 'numero de organismos por 500 mililitros'),
(895, 'number of organisms per liter', 'numero de organismos por litro'),
(896, 'number of organisms per square meter', 'numero de organismos por metro cuadrado'),
(897, 'number or organisms per cubic meter', 'numero de organismos por metros cubicos'),
(898, 'Observation in, of or sample taken from snow', 'Observación en, de o muestra tomada desde nieve'),
(899, 'Observation of a variable using a field instrument', 'Observación de una variable usando un instrumento de campo'),
(900, 'Observation or sample of surface water such as a stream, river, lake, pond, reservoir, ocean, etc.', 'Observación o muestra de superficie del agua tal como un cauce, rio, lago, laguna, embalse, oceano, etc.'),
(901, 'Observation that is the result of analyzing a sample in a laboratory', 'Observación que es el resultado de analizar una muestra en un laboratorio'),
(902, 'Ocean', 'Océano'),
(903, 'oceans', 'océanos'),
(904, 'Odor', 'Olor'),
(905, 'ohm meter', 'ohm metro'),
(906, 'oocysts per 10 liters', 'oocysts por 10 litros'),
(907, 'oocysts per 100 liters', 'oocysts por 100 litros'),
(908, 'Organic Kjeldahl (organic nitrogen + ammonia (NH3) + ammonium (NH4)) nitrogen', 'Kjeldahl Orgánico (nitrogeno organico + amoniaco (NH3) + amonio (NH4)) nitrogeno'),
(909, 'Organic Nitrogen', 'Nitrogeno Organico'),
(910, 'Organic Phosphorus', 'Fosforo Orgánico'),
(911, 'Organic Sulfur', 'Sulfuro Organico'),
(912, 'Organism Concentration', 'Concentración de Organismos'),
(913, 'Orthophosphate Phosphorus', 'Fosforo Ortfosfatado'),
(914, 'Other', 'Otro'),
(915, 'ounce', 'onza'),
(916, 'ounce force', 'onza de fuerza'),
(917, 'Outcrop', 'Afloramiento'),
(918, 'Outfall', 'Desagüe'),
(919, 'Outgoing Longwave Radiation', 'Radiación Saliente de Onda Larga'),
(920, 'Outgoing Photosynthetically-Active Radiation', 'Radiación Saliente Fotosinteticamente-Activa'),
(921, 'Outgoing rate of heat energy transfer minus the incoming rate of heat energy transfer through a given area', 'Tasa saliente de energia de calor transferida menos la tasa entrante de energía de calor transferida a traves de un área dada'),
(922, 'Outgoing Shortwave Radiation', 'Radiación Saliente de Onda Corta'),
(923, 'Oxidation-reduction potential', 'Potencial de Oxidación-reducción'),
(924, 'Oxygen (O2) flux', 'Flujo de Oxígeno (O2)'),
(925, 'Oxygen flux', 'Oxígeno Flujo'),
(926, 'Oxygen, dissolved', 'Oxígeno, Disuelto'),
(927, 'Oxygen, dissolved percent of saturation', 'Oxígeno, Disuelto Porcentaje de Saturación'),
(928, 'Oxygen, dissolved, transducer signal', 'Oxígeno, Disuelto, Señal del Transductor'),
(929, 'Oxygen-18', 'Oxígeno-18'),
(930, 'Oxygen-18, stable isotope ratio delta', 'Oxígeno-18, Estable Relación Isotópica Delta'),
(931, 'Ozone', 'Ozono'),
(932, 'Ozone (O3)', 'Ozono (O3)'),
(933, 'Parameter', 'Parametro'),
(934, 'Parameter related to a hydrologic process.  An example usage would be for a starge-discharge relation parameter.', 'Parametro relacionado a un proceso hidrologico. Un ejemplo de uso seria el del parametro de la relación elevación-caudal.'),
(935, 'Particulate organic carbon in suspension', 'Partículado de carbono orgánico en suspensión'),
(936, 'Particulate Organic Nitrogen', 'Nitrogeno Organico particulado'),
(937, 'Particulate organic phosphorus in suspension', 'Fósforo orgánico particulado en suspensión'),
(938, 'Particulate phosphorus', 'Fosforo Particulado'),
(939, 'parts per billion', 'partes por billon'),
(940, 'parts per million', 'partes por millon'),
(941, 'parts per quadrillion', 'partes por quadrillon'),
(942, 'parts per quintillion', 'partes por quintillon'),
(943, 'parts per thousand', 'partes por miles'),
(944, 'parts per trillion', 'partes por trillon'),
(945, 'Pavement', 'Pavimento'),
(946, 'per day', 'por dia'),
(947, 'per liter', 'por litro'),
(948, 'per meter', 'por metro'),
(949, 'per mille', 'por milla'),
(950, 'per mille by volume', 'por milla por volumen'),
(951, 'per mille per hour', 'por milla por hora'),
(952, 'per mille per hour by volume', 'por milla por hora por volumen'),
(953, 'percent', 'porcentaje'),
(954, 'percent by volume', 'percent por volumen'),
(955, 'Percent Saturation', 'Porcentaje de Saturación'),
(956, 'Permeability', 'Permeabilidad'),
(957, 'Permittivity is a physical quantity that describes how an electric field affects, and is affected by a dielectric medium, and is determined by the ability of a material to polarize in response to the field, and thereby reduce the total electric field inside the material. Thus, permittivity relates to a material''''s ability to transmit (or "permit") an electric field.', 'La Permitividad es una cantidad fisica que describe como un campo eléctrico afecta, y es afectado por un medio dielectrico, y se determina por la abilidad de un material de polarizar en respuesta al campo, y reduciendo asi el campo total electrico dentro del material. De esta manera, la permitividad se relaciona a la abilidad del material de transmitir (o ''permitir'') un campo electrico.'),
(958, 'Petroleum hydrocarbon, total', 'Petroleum Hidrocarburo, Total'),
(959, 'pH is the measure of the acidity or alkalinity of a solution. pH is formally a measure of the activity of dissolved hydrogen ions (H+).  Solutions in which the concentration of H+ exceeds that of OH- have a pH value lower than 7.0 and are known as acids. ', 'El pH es la medida de la acidez o alcalinidad de una solución. El pH es formalmente una medida de la actividad de los iones de hidrogeno disuelto (H+). Las soluciones en la cual la concentración de H+ excede aquella de OH- tienen un valor de pH menor que 7.0 y son conocidas como acidos. '),
(960, 'Pheophytin (Chlorophyll which has lost the central Mg ion) is a degradation product of Chlorophyll', 'Pheophytin (Clorofila que ha perdido el ion central de Mg ion) es un producto de la degradación de la clorofila'),
(961, 'Phosphate (PO4) flux', 'Flujo Fosfatado (PO4)'),
(962, 'Phosphate Phosphorus', 'Fósforo fosfatado'),
(963, 'Phosphorus, dissolved', 'Fosforo, Disuelto'),
(964, 'Phosphorus, dissolved organic', 'Fosforo, Disuelto Orgánico'),
(965, 'Phosphorus, inorganic ', 'Fosforo, Inorgánico '),
(966, 'Phosphorus, organic', 'Fosforo, Orgánico'),
(967, 'Phosphorus, orthophosphate', 'Fosforo, Orthofosfatado'),
(968, 'Phosphorus, orthophosphate dissolved', 'Fosforo, Orthofosfatado Disuelto'),
(969, 'Phosphorus, particulate', 'Fosforo, Particulado'),
(970, 'Phosphorus, particulate organic', 'Fosforo, Particulado Orgánico'),
(971, 'Phosphorus, phosphate (PO4)', 'Fosforo, Fosfatado (PO4)'),
(972, 'Phosphorus, phosphate flux', 'Fosforo, Fosfatado Flujo'),
(973, 'Phosphorus, polyphosphate', 'Fosforo, Polyfosfatado'),
(974, 'Phosphorus, total', 'Fosforo, Total'),
(975, 'Phosphorus, total dissolved', 'Fosforo, Total Disuelto'),
(976, 'phot', 'fot'),
(977, 'Phytoplankton', 'Fitoplancton'),
(978, 'picocuries per gram', 'picocuries por gramo'),
(979, 'picocuries per liter', 'picocuries por litro'),
(980, 'picocuries per milliliter', 'picocuries por mililitro'),
(981, 'picograms per cubic meter', 'picogramos per metro cubico'),
(982, 'picograms per liter', 'picogramos per litro'),
(983, 'picograms per milliliter', 'picogramos per millilitro'),
(984, 'pint', 'pinta'),
(985, 'planningCadastre', 'planificaciónCatastro'),
(986, 'plaque-forming units per 100 liters', 'placas-formantes unidades por 100 litros'),
(987, 'plaques per 100 milliliters', 'placas por 100 mililitros'),
(988, 'plaques/100 ml', 'placas/100 ml'),
(989, 'platinum cobalt units', 'platinum cobalto unidades'),
(990, 'Playa', 'Zona Salina'),
(991, 'Polyphosphate Phosphorus', 'Fosforo Polyfosfatado'),
(992, 'Position', 'Posición'),
(993, 'Position of an element that interacts with water such as reservoir gates', 'Posición de un elemento que interactua con el agua tal como compuertas de embalse'),
(994, 'Potassium', 'Potasio'),
(995, 'Potassium (K)', 'Potasio (K)'),
(996, 'Potassium, dissolved', 'Potasio, Disuelto'),
(997, 'Potential Difference', 'Diferencia Potencial'),
(998, 'pound force', 'libra de fuerza'),
(999, 'pound force per square inch', 'libra de fuerza por pulgada cuadrada'),
(1000, 'pound mass (avoirdupois)', 'libra masa (avoirdupois)'),
(1001, 'pounds per day', 'libras por day'),
(1002, 'pounds per mile', 'libras por milla'),
(1003, 'Power', 'Potencia'),
(1004, 'practical salinity scale', 'escala practica de salinidad'),
(1005, 'practical salinity units ', 'practica salinidad unidades '),
(1006, 'Precipitation', 'Precipitación'),
(1007, 'Precipitation such as rainfall. Should not be confused with settling.', 'Precipitación tal como lluvia. No debe ser confundida con asentamiento de una sustancia.'),
(1008, 'Pressure', 'Presión'),
(1009, 'Pressure relative to the local atmospheric or ambient pressure', 'Presion relativa a la presion local atmosferica o la presion ambiental'),
(1010, 'Pressure, absolute', 'Pressure, absoluta'),
(1011, 'Pressure, gauge', 'Pressure, Relativa'),
(1012, 'Pressure/Stress', 'Presión/tensión'),
(1013, 'Primary Productivity', 'Productividad Primaria'),
(1014, 'Production water', 'Agua de Producción'),
(1015, 'Productivity', 'Productividad'),
(1016, 'Program signature', 'Identificador del Progama'),
(1017, 'Pyritic Sulfur', 'azufre pirítica'),
(1018, 'Quality controlled data', 'Data con Control de Calidad'),
(1019, 'Quality controlled data that have passed quality assurance procedures such as routine estimation of timing and sensor calibration or visual inspection and removal of obvious errors. An example is USGS published streamflow records following parsing through USGS quality control procedures.', 'Data con control de calidad que han pasado los procedimientos de seguridad de calidad tales como las rutinas de estimación del tiempo y la calibración del sensor o la inspección visual y la eliminación de errores obvios. Un ejemplo de esto son los registros de caudales publicados por el USGS siguiendo la desagregación a traves de los procedimientos de control de calidad del USGS.'),
(1020, 'quart', 'cuarto de galón'),
(1021, 'rad', 'radianes'),
(1022, 'radian', 'radianes'),
(1023, 'Radiation, incoming longwave', 'Radiación, Entrante de Onda Larga'),
(1024, 'Radiation, incoming PAR', 'Radiación, Entrante PAR'),
(1025, 'Radiation, incoming shortwave', 'Radiación, Entrante de Onda Corta'),
(1026, 'Radiation, incoming UV-A', 'Radiación, Entrante UV-A'),
(1027, 'Radiation, incoming UV-B', 'Radiación, Entrante UV-B'),
(1028, 'Radiation, net', 'Radiación, Neta'),
(1029, 'Radiation, net longwave', 'Radiación, Neta Onda Larga'),
(1030, 'Radiation, net PAR', 'Radiación, Neta PAR'),
(1031, 'Radiation, net shortwave', 'Radiación, Neta Onda Corta'),
(1032, 'Radiation, outgoing longwave', 'Radiación, Saliente Onda Larga'),
(1033, 'Radiation, outgoing PAR', 'Radiación, Saliente PAR'),
(1034, 'Radiation, outgoing shortwave', 'Radiación, Saliente Onda Corta'),
(1035, 'Radiation, total incoming', 'Radiación, Total Entrante'),
(1036, 'Radiation, total outgoing', 'Radiación, Total Saliente'),
(1037, 'Radiation, total shortwave', 'Radiación, Total Onda Corta'),
(1038, 'Radioactivity', 'Radioactividad'),
(1039, 'Rainfall rate', 'Intensidad de Lluvia'),
(1040, 'Raw and unprocessed data and data products that have not undergone quality control.  Depending on the variable, data type, and data transmission system, raw data may be available within seconds or minutes after the measurements have been made. Examples include real time precipitation, streamflow and water quality measurements.', 'Datos crudos y no procesados y productos de datos que no han pasado por control de calidad. Dependiendo de la variable, tipo de dato, y sistema de transmisión de los datos, la data cruda puede estar disponible dentro los segundos o minutos despues que se ha realizado la medida. Ejemplos incluyen medidas en tiempo real de precipitación, caudal y calidad de agua.'),
(1041, 'Raw data', 'Datos Crudos'),
(1042, 'Real dielectric constant', 'Real Constante Dieléctrica'),
(1043, 'Recorder code', 'Código de Registrador'),
(1044, 'Reduction potential', 'Potencial de Oxidación-Reducción'),
(1045, 'relative fluorescence units', 'fluorescencia relativa unidades'),
(1046, 'Relative humidity', 'Humedad Relativa'),
(1047, 'Reservoir storage', 'Volumen de Embalse'),
(1048, 'Reservoir water volume', 'Volumen de agua de un embalse'),
(1049, 'Resistance', 'Resistancia'),
(1050, 'Resistivity', 'Resistividad'),
(1051, 'Resolution', 'Resolución'),
(1052, 'Respiration, net', 'Respiración, Neta'),
(1053, 'Salicornia bigelovii coverage', 'Cobertura de Salicornia Bigelovii'),
(1054, 'Salicornia virginica coverage', 'Cobertura de Salicornia Virginica'),
(1055, 'Salinity', 'Salinidad'),
(1056, 'Sample', 'Muestra'),
(1057, 'Sample collected using an automated sampler', 'Muestra recolectada usando un muestreador automatizado'),
(1058, 'Sample medium not relevant in the context of the measurement', 'Muestra medio no relevante en el contexto de las medidas'),
(1059, 'Sample medium other than those contained in the CV', 'Muestra medio otra que aquellas contenida en el CV'),
(1060, 'Sample taken from raw municipal waste water stream.', 'Muestras tomadas desde cruda municipal corriente de aguas residuales.'),
(1061, 'Sample taken from solid or liquid precipitation', 'Muestra tomadas desde solida o precipitación liquida'),
(1062, 'Sample taken from the atmosphere', 'Muestra tomada de la atmósfera'),
(1063, 'Sample taken from the sediment beneath the water column', 'Muestra tomada desde el sedimento por debajo la columna de agua'),
(1064, 'Sample taken from the soil', 'Muestra tomada desde el suelo'),
(1065, 'Sample taken from the tissue of a biological organism', 'Muestra tomada desde el tejido de un organismo biologico'),
(1066, 'Sample taken from water located below the surface of the ground, such as from a well or spring', 'Muestra tomada de agua localizada por debajo de la superficie de la tierra, tales como desde un pozo o manatial'),
(1067, 'sample type can include a number of measured sample types including temperature, RH, solar radiation, precipitation, wind speed, wind direction.', 'tipo de muestra puede incluir un numeor de tipos de muestra medidas incluyendo temperatura, HR, radiación solar, precipitación, velocidad de viento, dirección de viento.'),
(1068, 'Scale', 'Escala'),
(1069, 'Secchi depth', 'Profundiad Secchi'),
(1070, 'second', 'segundo'),
(1071, 'Sediment', 'Sedimento'),
(1072, 'Sedimentation Rate', 'Tasa de Sedimentación'),
(1073, 'Selenium', 'Selenio'),
(1074, 'Selenium (Se)', 'Selenio (Se)'),
(1075, 'Sensible Heat Flux', 'Calor Sensible Flujo'),
(1076, 'Septic system', 'Sistema Séptico'),
(1077, 'Sequence number', 'Contador de Secuencia'),
(1078, 'Shore', 'Costa'),
(1079, 'short ton', 'tonelada corta'),
(1080, 'short tons per acre foot', 'short toneladas per acre foot'),
(1081, 'short tons per day', 'short toneladas por día'),
(1082, 'short tons per day per foot', 'toneladas cortas por día por pie'),
(1083, 'short tons per month', 'toneladas  cortas por mes'),
(1084, 'siemens per centimeter', 'siemens por centimetro'),
(1085, 'siemens per meter', 'siemens por metro'),
(1086, 'Signal-to-noise ratio', 'Tasa Senal-a-Ruido'),
(1087, 'Signal-to-noise ratio (often abbreviated SNR or S/N) is defined as the ratio of a signal power to the noise power corrupting the signal. The higher the ratio, the less obtrusive the background noise is.', 'Tasa Senal-a-ruido (suele abreviarse como SNR o S/N) es definida como la tasa de una senal de poder a la senal corrompida de poder de ruido. Mientras mas alta es la tasa, menor obtrusivo sera el ruido de fondo.'),
(1088, 'Silica', 'Sílice'),
(1089, 'Silica (SiO2)', 'Sílice (SiO2)'),
(1090, 'Silicate', 'Silicato'),
(1091, 'Silicate acid (H4SiO4) flux', 'Flujo de Acido Silicato (H4SiO4)'),
(1092, 'Silicate.  Chemical compound containing silicon, oxygen, and one or more metals, e.g., aluminum, barium, beryllium, calcium, iron, magnesium, manganese, potassium, sodium, or zirconium.', 'Silicato. Compuesto quimico que contiene silicio, oxigeno, y uno o mas metales, por ejemplo, aluminio, bario, berilio, calcio, hierro, magnesio, manganeso, potasio, sodio, o circonio.'),
(1093, 'Silicic acid', 'Silicato Acido'),
(1094, 'Silicic acid flux', 'Silicato Acido Flujo'),
(1095, 'Silicon', 'Silicio'),
(1096, 'Silicon (Si)  ', 'Silicio (Si)  '),
(1097, 'Silicon, dissolved', 'Silicio, Disuelto'),
(1098, 'Sinkhole', 'Sumidero'),
(1099, 'Site in the open ocean, gulf, or sea. (See also: Coastal, Estuary, and Tidal stream).', 'Sitio en el océano abierto, golfo, o al mar. (Ver también: Costa, estuario, y las corrientes de marea).'),
(1100, 'Snow', 'Nieve'),
(1101, 'Snow depth', 'Profundidad de Nieve'),
(1102, 'Snow Water Equivalent', 'Nieve Equivalente en Agua'),
(1103, 'society', 'sociedad'),
(1104, 'Sodium', 'Sodio'),
(1105, 'Sodium (Na)', 'Sodio (Na)'),
(1106, 'Sodium adsorption ratio', 'Sodio Tasa de Absorción'),
(1107, 'Sodium plus potassium', 'Sodio más potasio'),
(1108, 'Sodium, dissolved', 'Sodio, Disuelto'),
(1109, 'Sodium, fraction of cations', 'Sodio, Fracción de Cationes'),
(1110, 'Soil', 'Suelo'),
(1111, 'Soil air', 'Aire de Suelo'),
(1112, 'Soil hole', 'Hoyo de Suelo'),
(1113, 'Soil reponse of a reflected standing electromagnetic wave of a particular frequency which is related to the dissipation (or loss) of energy within the medium. This is the imaginary portion of the complex dielectric constant.', 'Respuesta del suelo de una onda electromagnética permanente reflejada de una frecuencia particular la cual esta relacionada a la disipación (o pérdida) de energía dentro de medio. Esta es la porción imaginaria de la ocnstante dielectrica compleja.'),
(1114, 'Soil reponse of a reflected standing electromagnetic wave of a particular frequency which is related to the stored energy within the medium.  This is the real portion of the complex dielectric constant.', 'Respuesta del Suelo a la onda estacionaria electromagnetica reflejada de una frecuencia particular la cual esta relacionada a la energia almacenada dentro el medio.  Esta es la porcion real de la constante compleja dielectrica.'),
(1115, 'Soil water', 'Agua de Suelo'),
(1116, 'Solar radiation, direct and diffuse, received from a solid angle of 2p steradians on a horizontal surface. \\nSource: World Meteorological Organization, Meteoterm', 'Radiación Solar, directa y difusa, recibida desde un angulo sólido de 2p esterorradianes sobre una superficie horizontal. \\nSource: World Meteorological Organization, Meteoterm'),
(1117, 'Solids, fixed Dissolved', 'Solidos, Fijos Disueltos'),
(1118, 'Solids, fixed Suspended', 'Solidos, Fijos Suspendidos'),
(1119, 'Solids, total', 'Solidos, Total'),
(1120, 'Solids, total Dissolved', 'Solidos, Total Disueltos'),
(1121, 'Solids, total Fixed', 'Solidos, Total Fijos'),
(1122, 'Solids, total Suspended', 'Solidos, Total Suspendidos'),
(1123, 'Solids, total Volatile', 'Solidos, Total Volatiles'),
(1124, 'Solids, volatile Dissolved', 'Solidos, Volatiles Disueltoa'),
(1125, 'Solids, volatile Suspended', 'Solidos, Suspendidos Volatiles'),
(1126, 'Something', 'Algo'),
(1127, 'Sound', 'Sonido'),
(1128, 'Spartina alterniflora coverage', 'Cobertura de Spartina Alterniflora'),
(1129, 'Spartina spartinea coverage', 'Cobertura de Spartina Spartinea'),
(1130, 'Speciation is not applicable', 'La especiation no es aplicable'),
(1131, 'Speciation is unknown', 'La especiación es desconocida'),
(1132, 'Specific Activity', 'Actividad Especifica'),
(1133, 'Specific conductance', 'Conductancia Específica'),
(1134, 'Specific UV Absorbance', 'Absorbancia UV Especifica'),
(1135, 'Speed of gusts of wind', 'Velocidad de las rafagas de viento'),
(1136, 'Sporadic', 'Esporádico'),
(1137, 'Spring', 'Fuente'),
(1138, 'square centimeter', 'centimetros cuadrados'),
(1139, 'square foot', 'pies cuadrados'),
(1140, 'square kilometer', 'kilometros cuadrados'),
(1141, 'square meter', 'metros cuadrados'),
(1142, 'square meters per gram', 'metros cuadrados por gramo'),
(1143, 'square mile', 'millas cuadradas'),
(1144, 'squared degree Celsius', 'grados Celsius cuadrados'),
(1145, 'StandardDeviation', 'Desviación Estándar'),
(1146, 'steradian', 'estereorradián'),
(1147, 'Storm sewer', 'Alcantarillado de Tormenta'),
(1148, 'Stream', 'Arroyo'),
(1149, 'Streamflow', 'Flujo'),
(1150, 'Streamwater Suspended Sediment', ' Sedimento suspendido del cauce'),
(1151, 'Streptococci, fecal', 'Estreptococos, Fecales'),
(1152, 'Strontium', 'Estroncio'),
(1153, 'Strontium (Sr)', 'Estroncio (Sr)'),
(1154, 'Strontium, dissolved', 'Estroncio, Disuelto'),
(1155, 'Strontium, total', 'Estroncio, Total'),
(1156, 'structure', 'estructura'),
(1157, 'Suaeda linearis coverage', 'Cobertura de Suaeda linearis'),
(1158, 'Suaeda maritima coverage', 'Cobertura de Suaeda maritima'),
(1159, 'Subsurface', 'Subsuperficie'),
(1160, 'Sulfate', 'Sulfato'),
(1161, 'Sulfate (SO4)', 'Sulfato (SO4)'),
(1162, 'Sulfate, dissolved', 'Sulfato, Disuelto'),
(1163, 'Sulfur', 'Azufre'),
(1164, 'Sulfur (S)', 'Azufre (S)'),
(1165, 'Sulfur dioxide', 'Dióxido de Azufre'),
(1166, 'Sulfur dioxide (SO2)', 'Dióxido de Azufre(SO2) disuelto'),
(1167, 'Sulfur, organic', 'Azufre, Organico'),
(1168, 'Sulfur, pyritic', 'Azufre, Pirítica'),
(1169, 'Sunshine duration', 'Duración del Tiempo Soleado'),
(1170, 'Surface Water', 'Agua Superficial'),
(1171, 'Suspended Inorganic Carbon', 'Carbon Inorgánico Suspendido'),
(1172, 'Suspended Total (Organic+Inorganic) Carbon', 'Carbon Suspendido Total (Orgánico+Inorgánico)'),
(1173, 'Table overrun error count', 'Tabla cuenta de errores rebasamiento'),
(1174, 'tablespoon', 'cucharada'),
(1175, 'TDR waveform relative length', 'TDR forma de onda de longitud relativa'),
(1176, 'teaspoon', 'cucharadita'),
(1177, 'Temperature', 'Temperatura'),
(1178, 'Temperature, dew point', 'Temperatura, Punto de Rocío'),
(1179, 'Temperature, raw data from sensor', 'Temperatura, data cruda del sensor'),
(1180, 'Temperature, transducer signal', 'Temperatura, Señal del Transductor'),
(1181, 'Test hole not completed as a well', 'Hoyo de Prueba no se Completa'),
(1182, 'Thallium (Tl)', 'Thalio (Tl)'),
(1183, 'The amount of water that could be evaporated and transpired if there was sufficient water available.', 'La cantidad de agua que podria evaporarse y transpirarse si hubiese suficiente agua disponible.'),
(1184, 'The battery temperature of a datalogger or sensing system', 'La temperatura de la bateria de un datalogger o sistema de sensores'),
(1185, 'The battery voltage of a datalogger or sensing system, often recorded as an indicator of data reliability', 'El voltaje de la bateria de un datalogger o sistema de sensores, frecuentemente registrado como un indicador de confiabilidad de los datos'),
(1186, 'The chlorophyll a concentration contributed by cryptophytes', 'La concentración de clorofila contribuida por criptofitas'),
(1187, 'The chlorophyll a concentration contributed by Dinoflagellates', 'La concentración de clorofila contribuida por dinoflagelados'),
(1188, 'The combination effect of heat and humidity on the temperature felt by people.', 'El efecto combinado del calor y la humedad sobre la temperatura sentida por las personas.'),
(1189, 'The concentration of colored dissolved organic matter (humic substances)', 'La concentración de materia organica coloreada disuelta (sustancias húmicas )'),
(1190, 'The data type is unknown', 'El tipo de datos es desconocido'),
(1191, 'The depth of water if a snow cover is completely melted, expressed in units of depth, on a corresponding horizontal surface area.', 'La profundidad de agua si una cobertura de nieve se derritiera por completo, expresada en unidades de profundidad, sobre un área de superficie correspondiente horizontal.'),
(1192, 'The difference between the actual water vapor pressure and the saturation of water vapor pressure at a particular temperature.', 'La diferencia entre la presión de vapor de agua actual y la presión de saturación de vapor de agua a una temperatura particular.'),
(1193, 'The effect of moisture settling on the surface of a leaf as a result of either condensation or rainfall.', 'El efecto de la humedad asentandose sobre la superficie de una hoja como un resultado de ya sea la condensación o la lluvia.'),
(1194, 'The effect of wind on the temperature felt on human skin.', 'El efecto del viento sobre la temperatura sentida sobre la piel humana.'),
(1195, 'The general category is unknown', 'La categoría general es desconocida'),
(1196, 'The height of a surface wave, measured as the difference in elevation between the wave crest and an adjacent trough.', 'La altura de una onda de agua, medida como la diferencia en elevación entre la cresta de la onda y la depresión adyacente.'),
(1197, 'The identifying number for a water sampler container.', 'El número identificador para un contenedor de muestreador de agua.'),
(1198, 'The land along the edge of the sea, a lake, or a wide river where the investigator considers the proximity of the water body to be important. Land adjacent to a reservoir, lake, impoundment, or oceanic site type is considered part of the shore when it includes a beach or bank between the high and low water marks.', 'La tierra a lo largo de la orilla del mar, un lago o un río ancho que el investigador considera que la proximidad de la masa de agua que sea importante. Terreno adyacente a un depósito, lago, embalse o oceánica tipo de sitio se considera parte de la orilla cuando se incluye una playa o un banco entre las marcas superior e inferior de agua.'),
(1199, 'The length of flow of air past a point over a time interval. Windspeed times the interval of time.', 'La longitud del flujo de aire que pasa un punto a lo largo de un intervalo de tiempo. Velocidad del viento multiplicada por el intervalo de tiempo.'),
(1200, 'The number of fish identified by the detection equipment', 'El número de peces identificados por equipo de detección'),
(1201, 'The part of a rock formation that appears at the surface of the surrounding land.', 'La parte de una formación rocosa que aparece en la superficie de la tierra circundante.'),
(1202, 'The phenomenon is sampled at a particular instant in time but with a frequency that is too coarse for interpreting the record as continuous.  This would be the case when the spacing is significantly larger than the support and the time scale of fluctuation of the phenomenon, such as for example infrequent water quality samples.', 'El fenomeno es muestreado en un instante particular en el tiempo pero con una frecuencia que es muy gruesa para que se interprete el registro como continuo. Este seria el caso cuando el espaciamiento es significativamente mas largo que el soporte y la escala de tiempo de la fluctuación del fénomeno, tal como por ejemplo los muestreos infrecuentes (no frecuentes) de calidad de agua.'),
(1203, 'The phytoplankton pigment ', 'El pigmento de fitoplancton '),
(1204, 'The phytoplankton pigment 19-Hexanoyloxyfucoxanthin', 'El pigmento de fitoplancton 19-hexanoiloxifucoxantina'),
(1205, 'The phytoplankton pigment Alloxanthin', 'El pigmento de fitoplancton Alloxanthin'),
(1206, 'The phytoplankton pigment Canthaxanthin', 'El pigmento de fitoplancton Canthaxanthin'),
(1207, 'The phytoplankton pigment Chlorophyll a allomer', 'El pigmento de fitoplancton Clorofila un alomero'),
(1208, 'The phytoplankton pigment Diadinoxanthin', 'El pigmento de fitoplancto Diadinoxanthin'),
(1209, 'The phytoplankton pigment Diatoxanthin', 'El pigmento de fitoplancton Diatoxanthin'),
(1210, 'The phytoplankton pigment Peridinin', 'El pigmento de fitoplancton Peridinin'),
(1211, 'The phytoplankton pigment Zeaxanthin', 'El pigmento de fitoplancton Zeaxanthin'),
(1212, 'The portion of streamflow (discharge) that is supplied by groundwater sources.', 'La porción del flujo del cauce (caudal) que es suministrada por fuentes de aga subterranea.'),
(1213, 'The pressure exerted by the fluid at the wellhead or casinghead after the well has been shut off for a period of time, typically 24 hours', 'La presión ejercida por el fluido en la cabeza del pozo o la cabeza del encamisado despues que el pozo ha estado cerrado durante un periodo de tiempo, tipicamente 24 horas'),
(1214, 'The pressure of a vapor in equilibrium with its non-vapor phases', 'La presión de un vapor en equilibrio con sus fases de no-vapor'),
(1215, 'The quality control level is unknown', 'El nivel de control de calidad es desconocido'),
(1216, 'the ratio between UV absorbance at 254 nm and DOC level', 'la tasa entre la absorbancia UV e 254 nm y nivel DOC'),
(1217, 'The ratio of reflected to incident light.', 'EL cociente o tasa de la luz incidente reflejada.'),
(1218, 'The sample medium is unknown', 'El medio de muestra es desconocido'),
(1219, 'The sample type is unknown', 'El tipo de muestra es desconcido'),
(1220, 'The spatial reference system is unknown', 'El sistema de referencia espacial es desconocido'),
(1221, 'The THSW Index uses temperature, humidity, solar radiation, and wind speed to calculate an apparent temperature.', 'El indice THSW usa temperatura, humidad, radiación solar, y velocidad del viento para calcular una temperatura aparente.'),
(1222, 'The THW Index uses temperature, humidity, and wind speed to calculate an apparent temperature.', 'El indice THSW usa temperatura, humidad, radiación solar, y velocidad del viento para calcular una temperatura aparente.'),
(1223, 'The topic category is unknown', 'La categoria del topico es desconcida'),
(1224, 'The value type is unknown', 'El tipo de valor es desconocido'),
(1225, 'The values are categorical rather than continuous valued quantities. Mapping from Value values to categories is through the CategoryDefinitions table.', 'Los valores son categóricos mas que cantidades valoradas como continuas. El mapeo de Valor valores a categorías se hace a traves de la tabla CategoryDefinitions.'),
(1226, 'The values are quantities that can be interpreted as constant for all time, or over the time interval to a subsequent measurement of the same variable at the same site.', 'Los valores son cantidades que pueden ser interpretadas como constantes todo el tiempo, o durante el intervalo de tiempo hasta una medida subsecuente de la misma variable en el mismo sitio.'),
(1227, 'The values are the maximum values occurring at some time during a time interval, such as annual maximum discharge or a daily maximum air temperature.', 'Los valores son los valores máximos que occurren en un tiempo durante un intervalo de tiempo, tal como el caudal máximo anual o la temperatura máxima diaria.'),
(1228, 'The values are the minimum values occurring at some time during a time interval, such as 7-day low flow for a year or the daily minimum temperature.', 'Los valores son los valores mínimos que ocurren en algun tiempo durante un intervalo de tiempo, tal como el flujo bajo de 7-días para un año o la temperatura mínima diaria.'),
(1229, 'The values are the most frequent values occurring at some time during a time interval, such as annual most frequent wind direction.', 'Los valores son los valores que mas frecuentemente ocurren en algun tiempo durante un intervalo de tiempo, tal como la direccion del viento mas frecuente anualmente.'),
(1230, 'The values represent the average over a time interval, such as daily mean discharge or daily mean temperature.', 'Los valores representan el promedio durante un intervalo de tiempo, tal como un caudal medio diario o la temperatura media diaria.'),
(1231, 'The values represent the cumulative value of a variable measured or calculated up to a given instant of time, such as cumulative volume of flow or cumulative precipitation.', 'Los valores representan el valor acumulado de una variable medida o calculada hasta un instante dado de tiempo, tal como el volumen de flujo acumulado o la precipitación acumulada.'),
(1232, 'The values represent the incremental value of a variable over a time interval, such as the incremental volume of flow or incremental precipitation.', 'Los valores representan el valor incremental de una variable a lo largo de un intervalo de tiempo, tal como el volumen de flujo acumulado o la precipitación acumulada.'),
(1233, 'The values represent the median over a time interval, such as daily median discharge or daily median temperature.', 'Los valores representan  la mediana a lo largo de un intervalo de tiempo, tal como la mediana del caudal diario o la mediana d ela temperatura diaria.'),
(1234, 'The values represent the standard deviation of a set of observations made over a time interval. Standard deviation computed using the unbiased formula SQRT(SUM((Xi-mean)^2)/(n-1)) are preferred. The specific formula used to compute variance can be noted in the methods description.', 'Los valores representan la desviación estándar dde un conjunto de observaciones realizadas  a lo largo de un intervalo de tiempo. Se prefiere la desviación estándar calculada usando la fórmula no sesgada SQRT(SUM((Xi-media)^2)/(n-1)). La fórmula específica usada para calcular la varianza puede ser anotada en la descripción de los  métodos.'),
(1235, 'The values represent the variance of a set of observations made over a time interval.  Variance computed using the unbiased formula SUM((Xi-mean)^2)/(n-1) are preferred.  The specific formula used to compute variance can be noted in the methods description.', 'Los valores representan la varianza de un conjunto de observaciones realizadas a lo largo de un intervalo de tiempo. Se prefiere la varianza es calculada usando la fórmula no sesgada SUM((Xi-mean)^2)/(n-1).  La fórmula específica usada para calcular la varianza pude ser anotada en la descripción de los métodos.'),
(1236, 'The velocity of a substance, fluid or object', 'La velocidad de una sustancia, fluido u objeto'),
(1237, 'The vertical datum is unknown', 'El Datum Vertical es desconocido.'),
(1238, 'The vertical datum is unknown.', 'El Datum Vertical es desconocido.'),
(1239, 'The volume of water flowing past a fixed point. ', 'El volumen de agua fluyendo que pasa por un punto fijo. '),
(1240, 'the water contained in the soil pores', 'el agua contenida en los poros del suelo'),
(1241, 'There is no lab sample associated with this measurement', 'No hay muestra de laboratorio asociada con este medida'),
(1242, 'Thermoelectric plant', 'Planta Termoeléctrica'),
(1243, 'thousand acre feet', 'miles de acre pies'),
(1244, 'thousand gallons', 'miles de galones'),
(1245, 'THSW Index', 'THSW Indice'),
(1246, 'THW Index', 'THW Indice'),
(1247, 'Tidal stage', 'Fase de Marea'),
(1248, 'Tidal stream', 'Corrientes de Marea'),
(1249, 'Tide stage', 'Fase de Marea'),
(1250, 'Time domain reflextometry, apparent length divided by probe length. Square root of dielectric', 'Dominio de tiempo de reflextometria, longitud aparente dividida por la longitud de probeta. Raiz cuadrada de dielectrico'),
(1251, 'Tin', 'Estaño'),
(1252, 'Tin (Sn)', 'Estaño (Sn)'),
(1253, 'Tissue', 'Tejido'),
(1254, 'Titanium', 'Titanio'),
(1255, 'Titanium (Ti)', 'Titanio (Ti)'),
(1256, 'ton/month', 'ton/mes'),
(1257, 'tons of calcium carbonate per kiloton', 'toneladas de carbonato de calcio por kiloton'),
(1258, 'Total (dissolved + particulate) organic nitrogen', 'Total (disuelto + particulado) nitrogeno organico'),
(1259, 'Total (Dissolved+Particulate) Carbon', 'Total (Disuelto+Particulado) Carbon'),
(1260, 'Total (Dissolved+Particulate) Inorganic Carbon', 'Total (Disuelto+Particulado) Carbon Inorgánico'),
(1261, 'Total (Dissolved+Particulate) Organic Carbon', 'Total (Disuelto+Particulado) Carbon Orgánico'),
(1262, 'Total (free+ionized) Ammonia', '(libre+ionizado) Amoniaco Total'),
(1263, 'Total Alkalinity', 'Alcalinidad Total'),
(1264, 'Total amount of incoming radiation from all frequencies', 'Cantidad Total de radiación Entrante de todas las frecuencias'),
(1265, 'Total amount of outgoing radiation from all frequencies', 'Cantidad Total de radiación saliente de todas las frecuencias'),
(1266, 'Total Barium (Ba)', 'Bario Total (Ba)'),
(1267, 'Total biomass', 'Biomasa Total'),
(1268, 'Total Chloride (Cl-)', 'Cloruro Total (Cl-)'),
(1269, 'Total Coliform', 'Coliforme total'),
(1270, 'Total dissolved nitrogen', 'Total nitrogeno disuelto '),
(1271, 'Total dissolved phosphorus', 'Total de fosforo disuelto'),
(1272, 'Total Dissolved Solids', 'Total de Sólidos disueltos'),
(1273, 'Total Fixed Solids', 'Total de Solids Fijos'),
(1274, 'Total hardness', 'Dureza Total'),
(1275, 'Total Inorganic Nitrogen', 'Nitrogeno inorganico Total'),
(1276, 'Total Kjeldahl Nitrogen (Ammonia+Organic) ', 'Total Kjeldahl Nitrogeno (Amoniaco+Organico) '),
(1277, 'Total mass of phytoplankton, per unit area or volume', 'Masa Total de fitoplancton, por unidad de área o volumen'),
(1278, 'Total Nitrogen (NO3+NO2+NH4+NH3+Organic)', 'Nitrogeno Total (NO3+NO2+NH4+NH3+Organico)'),
(1279, 'Total petroleum hydrocarbon', 'Petroleo hidrocarburo total'),
(1280, 'Total Phosphorus', 'Fosforo Total'),
(1281, 'Total Shortwave Radiation', 'Radiación Total de Onda Corta'),
(1282, 'Total solid phase carbon', 'Total de carbono fase sólida'),
(1283, 'Total Solids', 'Solidos Totales'),
(1284, 'Total Strontium (Sr)', 'Estroncio Total(Sr)'),
(1285, 'Total Suspended Solids', 'Total de Solidos Suspendidos'),
(1286, 'Total Volatile Solids', 'Total de Solidos Volatiles'),
(1287, 'Transient species coverage', 'Cobertura de transient species'),
(1288, 'Transpiration', 'Transpiración'),
(1289, 'transportation', 'transportación'),
(1290, 'tritium units', 'tritium unidades'),
(1291, 'Trivalent Chromium', 'Cromo Trivalente'),
(1292, 'Tunnel, shaft, or mine', 'Túnel, Pullazo, o Mina'),
(1293, 'Turbidity', 'Turbidez'),
(1294, 'Ultimate Biochemical Oxygen Demand', 'Demanda Ultima Bioquímica de Oxígeno'),
(1295, 'Unknown', 'Desconocido'),
(1296, 'Unsaturated zone', 'Zona no Saturada'),
(1297, 'Uranium', 'Uranio'),
(1298, 'Uranium (U)', 'Uranio (U)'),
(1299, 'Urea ((NH2)2CO) flux', 'Flujo de Urea ((NH2)2CO)'),
(1300, 'Urea flux', 'Flujo de Urea'),
(1301, 'US gallon', 'US galon'),
(1302, 'utilitiesCommunication', 'serviciosComunicación'),
(1303, 'Value that is directly derived from an observation or set of observations', 'Valor que esta directament derivado de una observación o conjunto de observaciones'),
(1304, 'Values generated by a simulation model', 'Valores generados por un modelo de simulación'),
(1305, 'Vanadium', 'Vanadio'),
(1306, 'Vanadium (V)', 'Vanadio (V)'),
(1307, 'Vapor pressure', 'Presión de Vapor'),
(1308, 'Vapor pressure deficit', 'Déficit de Presión de Vapor'),
(1309, 'Variance', 'Varianza'),
(1310, 'Velocity', 'Velocidad'),
(1311, 'Vent from which volcanic gases escape to the atmosphere. Also known as fumarole.', 'Vent de la que los gases volcánicos se escapan a la atmósfera. También conocido como fumarola.'),
(1312, 'Visibility', 'Visibilidad'),
(1313, 'Volatile Dissolved Solids', 'Solidos volatiles disueltos'),
(1314, 'Volatile Suspended Solids', 'Solidos Suspendidos Volatiles disuelto'),
(1315, 'Volatilization Rate', 'Tasa de Volatilización'),
(1316, 'Volcanic vent', 'Respiradero Volcánico'),
(1317, 'Voltage', 'Voltaje'),
(1318, 'Voltage or Electrical Potential', 'Voltaje o Potencial Electrico'),
(1319, 'voltampere', 'voltamperio'),
(1320, 'Volume', 'Volumen'),
(1321, 'Volume of liquid water relative to bulk volume. Used for example to quantify soil moisture', 'Volumen de agua líquida relativa al volumen total. Usado por ejemplo para cuantificar humedad del suelo'),
(1322, 'Volume. To quantify discharge or hydrograph volume or some other volume measurement.', 'Volumen. Para cuantificar caudal o volumen de hidrograma o alguna otra medida de volumen.'),
(1323, 'Volumetric water content', 'Volumen de Agua Líquida'),
(1324, 'Waste injection well', 'Pozo de Inyección de Residuos'),
(1325, 'Wastewater land application', 'Aplicación al Suelo de Aguas Residuales'),
(1326, 'Wastewater sewer', 'Alcantarillado de Aguas Residuales'),
(1327, 'Wastewater-treatment plant', 'Planta de Tratamiento de Aguas Residuales'),
(1328, 'Watchdog error count', 'Cuenta de Errores');
INSERT INTO `spanish` (`ID`, `EngText`, `SpanishText`) VALUES
(1329, 'Water depth', 'Profundidad de Agua'),
(1330, 'Water depth averaged over a channel cross-section or water body. ', 'Profundidad de agua promediada a lo largo de una sección transversal de canal o cuerpo de agua. '),
(1331, 'Water depth is the distance between the water surface and the bottom of the water body at a specific location specified by the site location and offset.', 'Profundidad de agua es la distancia entre la superficie del agua y el fondo del cuerpo de agua en una localización especifica especificada por la localización del sitio y el offset.'),
(1332, 'Water depth, averaged', 'Profundidad de Agua, promediada'),
(1333, 'Water flux', 'Flujo de Agua'),
(1334, 'Water level', 'Nivel de Agua'),
(1335, 'Water level relative to datum. The datum may be local or global such as NGVD 1929 and should be specified in the method description for associated data values.', 'Nivel del agua relativo a un datum. El datum puede ser local o global tal como NGVD 1929 y debe ser especificado en la descripción del método para valores de datos asociados.'),
(1336, 'Water level with regard to an arbitrary gage datum (also see Water depth for comparison)', 'Nivel de agua con relación a un datum de medicion arbitrario (ver tambien Profundidad de Agua para comparación)'),
(1337, 'Water potential', 'Potencial Hídrico'),
(1338, 'Water potential is the potential energy of water relative to pure free water (e.g. deionized water) in reference conditions. It quantifies the tendency of water to move from one area to another due to osmosis, gravity, mechanical pressure, or matrix effects including surface tension.', 'Potencial de agua es la energia potencial del agua relativa a agua libre pura (por ejemplo, agua desionizada) en condiciones de referencia. Cuantifica la tendencia del agua de moverse de un área a otra debido a osmosis, gravedad, presión mecanica, o efectos matriciales incluyendo presión de tensión superficial.'),
(1339, 'Water Quality', 'Calidad de Agua'),
(1340, 'Water vapor density', 'Densidad del Vapor de Agua'),
(1341, 'Water-distribution system', 'Sistema de Distribución de Agua'),
(1342, 'Water-supply treatment plant', 'Planta de Tratamiento de Agua de Abastecimiento'),
(1343, 'Water-use establishment', 'Establecimiento del Uso de Agua'),
(1344, 'watts per square centimeter', 'watts por centimetro cuadrado'),
(1345, 'watts per square meter', 'watts por metros cuadrados'),
(1346, 'Wave height', 'Altura de Olas'),
(1347, 'Weather conditions', 'Condiciones  del Clima'),
(1348, 'week', 'semana'),
(1349, 'Well', 'Pozo'),
(1350, 'Well flow rate', 'Velocidad de flujo del Pozo'),
(1351, 'Wellhead pressure', 'Presión del Manantial'),
(1352, 'Wetland', 'Humedales'),
(1353, 'Wind chill', 'Sensación Térmica del Viento'),
(1354, 'Wind direction', 'Dirección del Viento'),
(1355, 'Wind gust direction', 'Dirección de Rafagas del Viento'),
(1356, 'Wind gust speed', 'Velocidad de Ráfagadel de Viento'),
(1357, 'Wind Run', 'Recorrido del Viento'),
(1358, 'Wind speed', 'Velocidad del Viento'),
(1359, 'Wind stress', 'Estrés del Viento'),
(1360, 'Wrack coverage', 'Cobertura de Fuco'),
(1361, 'year day (Julian)', 'year dia (Julian)'),
(1362, 'year month day', 'ayear mes day'),
(1363, 'yr', 'año'),
(1364, 'Zinc, dissolved', 'Zinc, Disuelto'),
(1365, 'Zircon, dissolved', 'Zirconio, Disuelto'),
(1366, 'Zooplankton', 'Zooplanctonicos'),
(1367, 'Zooplanktonic organisms, non-specific', 'Organismos Zooplanctonicos, no-especificos');


-- --------------------------------------------------------

--
-- Table structure for table `datavalues`
--

DROP TABLE IF EXISTS `datavalues`;
CREATE TABLE IF NOT EXISTS `datavalues` (
  `ValueID` int(11) NOT NULL AUTO_INCREMENT,
  `DataValue` double NOT NULL,
  `ValueAccuracy` double DEFAULT NULL,
  `LocalDateTime` datetime NOT NULL,
  `UTCOffset` double NOT NULL,
  `DateTimeUTC` datetime NOT NULL,
  `SiteID` int(11) NOT NULL,
  `VariableID` int(11) NOT NULL,
  `OffsetValue` double DEFAULT NULL,
  `OffsetTypeID` int(11) DEFAULT NULL,
  `CensorCode` varchar(50) NOT NULL DEFAULT 'nc',
  `QualifierID` int(11) DEFAULT NULL,
  `MethodID` int(11) NOT NULL DEFAULT '0',
  `SourceID` int(11) NOT NULL,
  `SampleID` int(11) DEFAULT NULL,
  `DerivedFromID` int(11) DEFAULT NULL,
  `QualityControlLevelID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ValueID`),
  UNIQUE KEY `DataValues_UNIQUE_DataValues` (`DataValue`,`ValueAccuracy`,`LocalDateTime`,`UTCOffset`,`DateTimeUTC`,`SiteID`,`VariableID`,`OffsetValue`,`OffsetTypeID`,`CensorCode`,`QualifierID`,`MethodID`,`SourceID`,`SampleID`,`DerivedFromID`,`QualityControlLevelID`),
  KEY `SiteID` (`SiteID`),
  KEY `SourceID` (`SourceID`),
  KEY `QualityControlLevelID` (`QualityControlLevelID`),
  KEY `OffsetTypeID` (`OffsetTypeID`),
  KEY `CensorCode` (`CensorCode`),
  KEY `VariableID` (`VariableID`),
  KEY `MethodID` (`MethodID`),
  KEY `QualifierID` (`QualifierID`),
  KEY `SampleID` (`SampleID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;



--
-- Table structure for table `derivedfrom`
--

DROP TABLE IF EXISTS `derivedfrom`;
CREATE TABLE IF NOT EXISTS `derivedfrom` (
  `DerivedFromID` int(11) NOT NULL,
  `ValueID` int(11) NOT NULL,
  KEY `ValueID` (`ValueID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `generalcategorycv`
--

DROP TABLE IF EXISTS `generalcategorycv`;
CREATE TABLE IF NOT EXISTS `generalcategorycv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `generalcategorycv`
--

INSERT INTO `generalcategorycv` (`Term`, `Definition`) VALUES
('Biota', 'Data associated with biological organisms'),
('Climate', 'Data associated with the climate, weather, or atmospheric processes'),
('Geology', 'Data associated with geology or geological processes'),
('Hydrology', 'Data associated with hydrologic variables or processes'),
('Instrumentation', 'Data associated with instrumentation and instrument properties such as battery voltages, data logger temperatures, often useful for diagnosis.'),
('Unknown', 'The general category is unknown'),
('Water Quality', 'Data associated with water quality variables or processes');

-- --------------------------------------------------------

--
-- Table structure for table `groupdescriptions`
--

DROP TABLE IF EXISTS `groupdescriptions`;
CREATE TABLE IF NOT EXISTS `groupdescriptions` (
  `GroupID` int(11) NOT NULL AUTO_INCREMENT,
  `GroupDescription` text,
  PRIMARY KEY (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
  `GroupID` int(11) NOT NULL,
  `ValueID` int(11) NOT NULL,
  KEY `GroupID` (`GroupID`),
  KEY `ValueID` (`ValueID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `isometadata`
--

DROP TABLE IF EXISTS `isometadata`;
CREATE TABLE IF NOT EXISTS `isometadata` (
  `MetadataID` int(11) NOT NULL AUTO_INCREMENT,
  `TopicCategory` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Title` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Abstract` text NOT NULL,
  `ProfileVersion` varchar(255) NOT NULL DEFAULT 'Unknown',
  `MetadataLink` text,
  PRIMARY KEY (`MetadataID`),
  KEY `TopicCategory` (`TopicCategory`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `isometadata`
--

INSERT INTO `isometadata` (`MetadataID`, `TopicCategory`, `Title`, `Abstract`, `ProfileVersion`, `MetadataLink`) VALUES
(1, 'Unknown', 'Unknown', 'Unknown', 'Unknown', NULL);


-- --------------------------------------------------------

--
-- Table structure for table `labmethods`
--

DROP TABLE IF EXISTS `labmethods`;
CREATE TABLE IF NOT EXISTS `labmethods` (
  `LabMethodID` int(11) NOT NULL,
  `LabName` varchar(255) NOT NULL DEFAULT 'Unknown',
  `LabOrganization` varchar(255) NOT NULL DEFAULT 'Unknown',
  `LabMethodName` varchar(255) NOT NULL DEFAULT 'Unknown',
  `LabMethodDescription` text NOT NULL,
  `LabMethodLink` text,
  PRIMARY KEY (`LabMethodID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `labmethods`
--

INSERT INTO `labmethods` (`LabMethodID`, `LabName`, `LabOrganization`, `LabMethodName`, `LabMethodDescription`, `LabMethodLink`) VALUES
(0, 'Unknown', 'Unknown', 'Unknown', 'Unknown', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `methods`
--

DROP TABLE IF EXISTS `methods`;
CREATE TABLE IF NOT EXISTS `methods` (
  `MethodID` int(11) NOT NULL AUTO_INCREMENT,
  `MethodDescription` text NOT NULL,
  `MethodLink` text,
  PRIMARY KEY (`MethodID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

--
-- Dumping data for table `methods`
--

INSERT INTO `methods` (`MethodID`, `MethodDescription`, `MethodLink`) VALUES
(1, 'No method specified', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `moss_users`
--

DROP TABLE IF EXISTS `moss_users`;
CREATE TABLE IF NOT EXISTS `moss_users` (
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `username` varchar(25) NOT NULL,
  `password` varchar(100) NOT NULL,
  `authority` enum('admin','teacher','student') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Table structure for table `moss_user_tokens`
--

DROP TABLE IF EXISTS `moss_user_tokens`;
CREATE TABLE IF NOT EXISTS `moss_user_tokens` (
  `TokenID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `token` varchar(100) NOT NULL,
  `issued` datetime NOT NULL,
  `expires` datetime NOT NULL,
  PRIMARY KEY (`TokenID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Table structure for table `odmversion`
--

DROP TABLE IF EXISTS `odmversion`;
CREATE TABLE IF NOT EXISTS `odmversion` (
  `VersionNumber` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `odmversion`
--

INSERT INTO `odmversion` (`VersionNumber`) VALUES
('1.1.1');

-- --------------------------------------------------------

--
-- Table structure for table `offsettypes`
--

DROP TABLE IF EXISTS `offsettypes`;
CREATE TABLE IF NOT EXISTS `offsettypes` (
  `OffsetTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `OffsetunitsID` int(11) NOT NULL,
  `OffsetDescription` text NOT NULL,
  PRIMARY KEY (`OffsetTypeID`),
  KEY `OffsetunitsID` (`OffsetunitsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `qualifiers`
--

DROP TABLE IF EXISTS `qualifiers`;
CREATE TABLE IF NOT EXISTS `qualifiers` (
  `QualifierID` int(11) NOT NULL AUTO_INCREMENT,
  `QualifierCode` varchar(50) DEFAULT NULL,
  `QualifierDescription` text NOT NULL,
  PRIMARY KEY (`QualifierID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `qualifiers`
--

INSERT INTO `qualifiers` (`QualifierID`, `QualifierCode`, `QualifierDescription`) VALUES
(1, 'cs', 'Citizen Science');

-- --------------------------------------------------------

--
-- Table structure for table `qualitycontrollevels`
--

DROP TABLE IF EXISTS `qualitycontrollevels`;
CREATE TABLE IF NOT EXISTS `qualitycontrollevels` (
  `QualityControlLevelID` int(11) NOT NULL,
  `QualityControlLevelCode` varchar(50) NOT NULL,
  `Definition` varchar(255) NOT NULL,
  `Explanation` text NOT NULL,
  PRIMARY KEY (`QualityControlLevelID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qualitycontrollevels`
--

INSERT INTO `qualitycontrollevels` (`QualityControlLevelID`, `QualityControlLevelCode`, `Definition`, `Explanation`) VALUES
(-9999, '-9999', 'Unknown', 'The quality control level is unknown'),
(0, '0', 'Raw data', 'Raw and unprocessed data and data products that have not undergone quality control.  Depending on the variable, data type, and data transmission system, raw data may be available within seconds or minutes after the measurements have been made. Examples include real time precipitation, streamflow and water quality measurements.'),
(1, '1', 'Quality controlled data', 'Quality controlled data that have passed quality assurance procedures such as routine estimation of timing and sensor calibration or visual inspection and removal of obvious errors. An example is USGS published streamflow records following parsing through USGS quality control procedures.'),
(2, '2', 'Derived products', 'Derived products that require scientific and technical interpretation and may include multiple-sensor data. An example is basin average precipitation derived from rain gages using an interpolation procedure.'),
(3, '3', 'Interpreted products', 'Interpreted products that require researcher driven analysis and interpretation, model-based interpretation using other data and/or strong prior assumptions. An example is basin average precipitation derived from the combination of rain gages and radar return data.'),
(4, '4', 'Knowledge products', 'Knowledge products that require researcher driven scientific interpretation and multidisciplinary data integration and include model-based interpretation using other data and/or strong prior assumptions. An example is percentages of old or new water in a hydrograph inferred from an isotope analysis.');

-- --------------------------------------------------------

--
-- Table structure for table `samplemediumcv`
--

DROP TABLE IF EXISTS `samplemediumcv`;
CREATE TABLE IF NOT EXISTS `samplemediumcv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `samplemediumcv`
--

INSERT INTO `samplemediumcv` (`Term`, `Definition`) VALUES
('Air', 'Sample taken from the atmosphere'),
('Flowback water', 'A mixture of formation water and hydraulic fracturing injectates deriving from oil and gas wells prior to placing wells into production'),
('Groundwater', 'Sample taken from water located below the surface of the ground, such as from a well or spring'),
('Municipal waste water', 'Sample taken from raw municipal waste water stream.'),
('Not Relevant', 'Sample medium not relevant in the context of the measurement'),
('Other', 'Sample medium other than those contained in the CV'),
('Precipitation', 'Sample taken from solid or liquid precipitation'),
('Production water', 'Fluids produced from wells during oil or gas production which may include formation water, injected fluids, oil and gas.'),
('Sediment', 'Sample taken from the sediment beneath the water column'),
('Snow', 'Observation in, of or sample taken from snow'),
('Soil', 'Sample taken from the soil'),
('Soil air', 'Air contained in the soil pores'),
('Soil water', 'the water contained in the soil pores'),
('Surface Water', 'Observation or sample of surface water such as a stream, river, lake, pond, reservoir, ocean, etc.'),
('Tissue', 'Sample taken from the tissue of a biological organism'),
('Unknown', 'The sample medium is unknown');

-- --------------------------------------------------------

--
-- Table structure for table `samples`
--

DROP TABLE IF EXISTS `samples`;
CREATE TABLE IF NOT EXISTS `samples` (
  `SampleID` int(11) NOT NULL AUTO_INCREMENT,
  `SampleType` varchar(255) NOT NULL,
  `LabSampleCode` varchar(50) NOT NULL,
  `LabMethodID` int(11) NOT NULL,
  PRIMARY KEY (`SampleID`),
  KEY `LabMethodID` (`LabMethodID`),
  KEY `SampleType` (`SampleType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `sampletypecv`
--

DROP TABLE IF EXISTS `sampletypecv`;
CREATE TABLE IF NOT EXISTS `sampletypecv` (
  `Term` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sampletypecv`
--

INSERT INTO `sampletypecv` (`Term`, `Definition`) VALUES
('Automated', 'Sample collected using an automated sampler'),
('FD ', ' Foliage Digestion'),
('FF ', ' Forest Floor Digestion'),
('FL ', ' Foliage Leaching'),
('Grab', 'Grab sample'),
('GW ', ' Groundwater'),
('LF ', ' Litter Fall Digestion'),
('meteorological', 'sample type can include a number of measured sample types including temperature, RH, solar radiation, precipitation, wind speed, wind direction.'),
('No Sample', 'There is no lab sample associated with this measurement'),
('PB  ', ' Precipitation Bulk'),
('PD ', ' Petri Dish (Dry Deposition)'),
('PE ', ' Precipitation Event'),
('PI ', ' Precipitation Increment'),
('PW ', ' Precipitation Weekly'),
('RE ', ' Rock Extraction'),
('SE ', ' Stemflow Event'),
('SR ', ' Standard Reference'),
('SS ', 'Streamwater Suspended Sediment'),
('SW ', ' Streamwater'),
('TE ', ' Throughfall Event'),
('TI ', ' Throughfall Increment'),
('TW ', ' Throughfall Weekly'),
('Unknown', 'The sample type is unknown'),
('VE ', ' Vadose Water Event'),
('VI ', ' Vadose Water Increment'),
('VW ', ' Vadose Water Weekly');

-- --------------------------------------------------------

--
-- Table structure for table `seriescatalog`
--

DROP TABLE IF EXISTS `seriescatalog`;
CREATE TABLE IF NOT EXISTS `seriescatalog` (
  `SeriesID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteID` int(11) DEFAULT NULL,
  `SiteCode` varchar(50) DEFAULT NULL,
  `SiteName` varchar(255) DEFAULT NULL,
  `SiteType` varchar(255) DEFAULT NULL,
  `VariableID` int(11) DEFAULT NULL,
  `VariableCode` varchar(50) DEFAULT NULL,
  `VariableName` varchar(255) DEFAULT NULL,
  `Speciation` varchar(255) DEFAULT NULL,
  `VariableunitsID` int(11) DEFAULT NULL,
  `VariableunitsName` varchar(255) DEFAULT NULL,
  `SampleMedium` varchar(255) DEFAULT NULL,
  `ValueType` varchar(255) DEFAULT NULL,
  `TimeSupport` double DEFAULT NULL,
  `TimeunitsID` int(11) DEFAULT NULL,
  `TimeunitsName` varchar(255) DEFAULT NULL,
  `DataType` varchar(255) DEFAULT NULL,
  `GeneralCategory` varchar(255) DEFAULT NULL,
  `MethodID` int(11) DEFAULT NULL,
  `MethodDescription` text,
  `SourceID` int(11) DEFAULT NULL,
  `Organization` varchar(255) DEFAULT NULL,
  `SourceDescription` text,
  `Citation` text,
  `QualityControlLevelID` int(11) DEFAULT NULL,
  `QualityControlLevelCode` varchar(50) DEFAULT NULL,
  `BeginDateTime` datetime DEFAULT NULL,
  `EndDateTime` datetime DEFAULT NULL,
  `BeginDateTimeUTC` datetime DEFAULT NULL,
  `EndDateTimeUTC` datetime DEFAULT NULL,
  `ValueCount` int(11) DEFAULT NULL,
  PRIMARY KEY (`SeriesID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=207 ;


--
-- Table structure for table `sitepic`
--

DROP TABLE IF EXISTS `sitepic`;
CREATE TABLE IF NOT EXISTS `sitepic` (
  `siteid` varchar(50) NOT NULL,
  `picname` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`siteid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Stores different picture for various sites';


--
-- Table structure for table `sites`
--

DROP TABLE IF EXISTS `sites`;
CREATE TABLE IF NOT EXISTS `sites` (
  `SiteID` int(11) NOT NULL AUTO_INCREMENT,
  `SiteCode` varchar(50) NOT NULL,
  `SiteName` varchar(255) NOT NULL,
  `Latitude` double NOT NULL,
  `Longitude` double NOT NULL,
  `LatLongDatumID` int(11) NOT NULL DEFAULT '0',
  `SiteType` varchar(255) DEFAULT NULL,
  `Elevation_m` double DEFAULT NULL,
  `VerticalDatum` varchar(255) DEFAULT NULL,
  `LocalX` double DEFAULT NULL,
  `LocalY` double DEFAULT NULL,
  `LocalProjectionID` int(11) DEFAULT NULL,
  `PosAccuracy_m` double DEFAULT NULL,
  `State` varchar(255) DEFAULT NULL,
  `County` varchar(255) DEFAULT NULL,
  `Comments` text,
  PRIMARY KEY (`SiteID`),
  UNIQUE KEY `AK_Sites_SiteCode` (`SiteCode`),
  KEY `VerticalDatum` (`VerticalDatum`),
  KEY `LatLongDatumID` (`LatLongDatumID`),
  KEY `LocalProjectionID` (`LocalProjectionID`),
  KEY `SiteType` (`SiteType`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


--
-- Table structure for table `sitetypecv`
--

DROP TABLE IF EXISTS `sitetypecv`;
CREATE TABLE IF NOT EXISTS `sitetypecv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sitetypecv`
--

INSERT INTO `sitetypecv` (`Term`, `Definition`) VALUES
('Aggregate groundwater use', 'An Aggregate Groundwater Withdrawal/Return site represents an aggregate of specific sites whe groundwater is withdrawn or returned which is defined by a geographic area or some other common characteristic. An aggregate groundwatergroundwater site type is used when it is not possible or practical to describe the specific sites as springs or as any type of well including ''multiple wells'', or when water-use information is only available for the aggregate. Aggregate sites that span multiple counties should be coded with 000 as the county code, or an aggregate site can be created for each county.'),
('Aggregate surface-water-use', 'An Aggregate Surface-Water Diversion/Return site represents an aggregate of specific sites where surface water is diverted or returned which is defined by a geographic area or some other common characteristic. An aggregate surface-water site type is used when it is not possible or practical to describe the specific sites as diversions, outfalls, or land application sites, or when water-use information is only available for the aggregate. Aggregate sites that span multiple counties should be coded with 000 as the county code, or an aggregate site can be created for each county.'),
('Aggregate water-use establishment', 'An Aggregate Water-Use Establishment represents an aggregate class of water-using establishments or individuals that are associated with a specific geographic location and water-use category, such as all the industrial users located within a county or all self-supplied domestic users in a county. The aggregate class of water-using establishments is identified using the national water-use category code and optionally classified using the Standard Industrial Classification System Code (SIC code) or North American Classification System Code (NAICS code). An aggregate water-use establishment site type is used when specific information needed to create sites for the individual facilities or users is not available or when it is not desirable to store the site-specific information in the database. Data entry rules that apply to water-use establishments also apply to aggregate water-use establishments. Aggregate sites that span multiple counties should be coded with 000 as the county code, or an aggregate site can be created for each county.'),
('Animal waste lagoon', 'A facility for storage and/or biological treatment of wastes from livestock operations. Animal-waste lagoons are earthen structures ranging from pits to large ponds, and contain manure which has been diluted with building washwater, rainfall, and surface runoff. In treatment lagoons, the waste becomes partially liquefied and stabilized by bacterial action before the waste is disposed of on the land and the water is discharged or re-used.'),
('Atmosphere', 'A site established primarily to measure meteorological properties or atmospheric deposition.'),
('Canal', 'An artificial watercourse designed for navigation, drainage, or irrigation by connecting two or more bodies of water; it is larger than a ditch.'),
('Cave', 'A natural open space within a rock formation large enough to accommodate a human. A cave may have an opening to the outside, is always underground, and sometimes submerged. Caves commonly occur by the dissolution of soluble rocks, generally limestone, but may also be created within the voids of large-rock aggregations, in openings along seismic faults, and in lava formations.'),
('Cistern', 'An artificial, non-pressurized reservoir filled by gravity flow and used for water storage. The reservoir may be located above, at, or below ground level. The water may be supplied from diversion of precipitation, surface, or groundwater sources.'),
('Coastal', 'An oceanic site that is located off-shore beyond the tidal mixing zone (estuary) but close enough to the shore that the investigator considers the presence of the coast to be important. Coastal sites typically are within three nautical miles of the shore.'),
('Collector or Ranney type well', 'An infiltration gallery consisting of one or more underground laterals through which groundwater is collected and a vertical caisson from which groundwater is removed. Also known as a "horizontal well". These wells produce large yield with small drawdown.'),
('Combined sewer', 'An underground conduit created to convey storm drainage and waste products into a wastewater-treatment plant, stream, reservoir, or disposal site.'),
('Ditch', 'An excavation artificially dug in the ground, either lined or unlined, for conveying water for drainage or irrigation; it is smaller than a canal.'),
('Diversion', 'A site where water is withdrawn or diverted from a surface-water body (e.g. the point where the upstream end of a canal intersects a stream, or point where water is withdrawn from a reservoir). Includes sites where water is pumped for use elsewhere.'),
('Estuary', 'A coastal inlet of the sea or ocean; esp. the mouth of a river, where tide water normally mixes with stream water (modified, Webster). Salinity in estuaries typically ranges from 1 to 25 Practical Salinity units (psu), as compared oceanic values around 35-psu. See also: tidal stream and coastal.'),
('Excavation', 'An artificially constructed cavity in the earth that is deeper than the soil (see soil hole), larger than a well bore (see well and test hole), and substantially open to the atmosphere. The diameter of an excavation is typically similar or larger than the depth. Excavations include building-foundation diggings, roadway cuts, and surface mines.'),
('Extensometer well', 'A well equipped to measure small changes in the thickness of the penetrated sediments, such as those caused by groundwater withdrawal or recharge.'),
('Facility', 'A non-ambient location where environmental measurements are expected to be strongly influenced by current or previous activities of humans. *Sites identified with a "facility" primary site type must be further classified with one of the applicable secondary site types.'),
('Field, Pasture, Orchard, or Nursery', 'A water-using facility characterized by an area where plants are grown for transplanting, for use as stocks for budding and grafting, or for sale. Irrigation water may or may not be applied.'),
('Glacier', 'Body of land ice that consists of recrystallized snow accumulated on the surface of the ground and moves slowly downslope (WSP-1541A) over a period of years or centuries. Since glacial sites move, the lat-long precision for these sites is usually coarse.'),
('Golf course', 'A place-of-use, either public or private, where the game of golf is played. A golf course typically uses water for irrigation purposes. Should not be used if the site is a specific hydrologic feature or facility; but can be used especially for the water-use sites.'),
('Groundwater drain', 'An underground pipe or tunnel through which groundwater is artificially diverted to surface water for the purpose of reducing erosion or lowering the water table. A drain is typically open to the atmosphere at the lowest elevation, in contrast to a well which is open at the highest point.'),
('Hydroelectric plant', 'A facility that generates electric power by converting potential energy of water into kinetic energy. Typically, turbine generators are turned by falling water.'),
('Hyporheic-zone well', 'A permanent well, drive point, or other device intended to sample a saturated zone in close proximity to a stream.'),
('Interconnected wells', 'Collector or drainage wells connected by an underground lateral.'),
('Laboratory or sample-preparation area', 'A site where some types of quality-control samples are collected, and where equipment and supplies for environmental sampling are prepared. Equipment blank samples are commonly collected at this site type, as are samples of locally produced deionized water. This site type is typically used when the data are either not associated with a unique environmental data-collection site, or where blank water supplies are designated by Center offices with unique station IDs.'),
('Lake, Reservoir, Impoundment', 'An inland body of standing fresh or saline water that is generally too deep to permit submerged aquatic vegetation to take root across the entire body (cf: wetland). This site type includes an expanded part of a river, a reservoir behind a dam, and a natural or excavated depression containing a water body without surface-water inlet and/or outlet.'),
('Land', 'A location on the surface of the earth that is not normally saturated with water. Land sites are appropriate for sampling vegetation, overland flow of water, or measuring land-surface properties such as temperature. (See also: Wetland).'),
('Landfill', 'A typically dry location on the surface of the land where primarily solid waste products are currently, or previously have been, aggregated and sometimes covered with a veneer of soil. See also: Wastewater disposal and waste-injection well.'),
('Multiple wells', 'A group of wells that are pumped through a single header and for which little or no data about the individual wells are available.'),
('Ocean', 'Site in the open ocean, gulf, or sea. (See also: Coastal, Estuary, and Tidal stream).'),
('Outcrop', 'The part of a rock formation that appears at the surface of the surrounding land.'),
('Outfall', 'A site where water or wastewater is returned to a surface-water body, e.g. the point where wastewater is returned to a stream. Typically, the discharge end of an effluent pipe.'),
('Pavement', 'A surface site where the land surface is covered by a relatively impermeable material, such as concrete or asphalt. Pavement sites are typically part of transportation infrastructure, such as roadways, parking lots, or runways.'),
('Playa', 'A dried-up, vegetation-free, flat-floored area composed of thin, evenly stratified sheets of fine clay, silt or sand, and represents the bottom part of a shallow, completely closed or undrained desert lake basin in which water accumulates and is quickly evaporated, usually leaving deposits of soluble salts.'),
('Septic system', 'A site within or in close proximity to a subsurface sewage disposal system that generally consists of: (1) a septic tank where settling of solid material occurs, (2) a distribution system that transfers fluid from the tank to (3) a leaching system that disperses the effluent into the ground.'),
('Shore', 'The land along the edge of the sea, a lake, or a wide river where the investigator considers the proximity of the water body to be important. Land adjacent to a reservoir, lake, impoundment, or oceanic site type is considered part of the shore when it includes a beach or bank between the high and low water marks.'),
('Sinkhole', 'A crater formed when the roof of a cavern collapses; usually found in limestone areas. Surface water and precipitation that enters a sinkhole usually evaporates or infiltrates into the ground, rather than draining into a stream.'),
('Soil hole', 'A small excavation into soil at the top few meters of earth surface. Soil generally includes some organic matter derived from plants. Soil holes are created to measure soil composition and properties. Sometimes electronic probes are inserted into soil holes to measure physical properties, and (or) the extracted soil is analyzed.'),
('Spring', 'A location at which the water table intersects the land surface, resulting in a natural flow of groundwater to the surface. Springs may be perennial, intermittent, or ephemeral.'),
('Storm sewer', 'An underground conduit created to convey storm drainage into a stream channel or reservoir. If the sewer also conveys liquid waste products, then the "combined sewer" secondary site type should be used.'),
('Stream', 'A body of running water moving under gravity flow in a defined channel. The channel may be entirely natural, or altered by engineering practices through straightening, dredging, and (or) lining. An entirely artificial channel should be qualified with the "canal" or "ditch" secondary site type.'),
('Subsurface', 'A location below the land surface, but not a well, soil hole, or excavation.'),
('Test hole not completed as a well', 'An uncased hole (or one cased only temporarily) that was drilled for water, or for geologic or hydrogeologic testing. It may be equipped temporarily with a pump in order to make a pumping test, but if the hole is destroyed after testing is completed, it is still a test hole. A core hole drilled as a part of mining or quarrying exploration work should be in this class.'),
('Thermoelectric plant', 'A facility that uses water in the generation of electricity from heat. Typically turbine generators are driven by steam. The heat may be caused by various means, including combustion, nuclear reactions, and geothermal processes.'),
('Tidal stream', 'A stream reach where the flow is influenced by the tide, but where the water chemistry is not normally influenced. A site where ocean water typically mixes with stream water should be coded as an estuary.'),
('Tunnel, shaft, or mine', 'A constructed subsurface open space large enough to accommodate a human that is not substantially open to the atmosphere and is not a well. The excavation may have been for minerals, transportation, or other purposes. See also: Excavation.'),
('Unsaturated zone', 'A site equipped to measure conditions in the subsurface deeper than a soil hole, but above the water table or other zone of saturation.'),
('Volcanic vent', 'Vent from which volcanic gases escape to the atmosphere. Also known as fumarole.'),
('Waste injection well', 'A facility used to convey industrial waste, domestic sewage, brine, mine drainage, radioactive waste, or other fluid into an underground zone. An oil-test or deep-water well converted to waste disposal should be in this category. A well where fresh water is injected to artificially recharge thegroundwaterr supply or to pressurize an oil or gas production zone by injecting a fluid should be classified as a well (not an injection-well facility), with additional information recorded under Use of Site.'),
('Wastewater land application', 'A site where the disposal of waste water on land occurs. Use "waste-injection well" for underground waste-disposal sites.'),
('Wastewater sewer', 'An underground conduit created to convey liquid and semisolid domestic, commercial, or industrial waste into a treatment plant, stream, reservoir, or disposal site. If the sewer also conveys storm water, then the "combined sewer" secondary site type should be used.'),
('Wastewater-treatment plant', 'A facility where wastewater is treated to reduce concentrations of dissolved and (or) suspended materials prior to discharge or reuse.'),
('Water-distribution system', 'A site located somewhere on a networked infrastructure that distributes treated or untreated water to multiple domestic, industrial, institutional, and (or) commercial users. May be owned by a municipality or community, a water district, or a private concern.'),
('Water-supply treatment plant', 'A facility where water is treated prior to use for consumption or other purpose.'),
('Water-use establishment', 'A place-of-use (a water using facility that is associated with a specific geographical point location, such as a business or industrial user) that cannot be specified with any other facility secondary type. Water-use place-of-use sites are establishments such as a factory, mill, store, warehouse, farm, ranch, or bank. A place-of-use site is further classified using the national water-use category code (C39) and optionally classified using the Standard Industrial Classification System Code (SIC code) or North American Classification System Code (NAICS code). See also: Aggregate water-use-establishment.'),
('Well', 'A hole or shaft constructed in the earth intended to be used to locate, sample, or develop groundwater, oil, gas, or some other subsurface material. The diameter of a well is typically much smaller than the depth. Wells are also used to artificially recharge groundwater or to pressurize oil and gas production zones. Additional information about specific kinds of wells should be recorded under the secondary site types or the Use of Site field. Underground waste-disposal wells should be classified as waste-injection wells.'),
('Wetland', 'Land where saturation with water is the dominant factor determining the nature of soil development and the types of plant and animal communities living in the soil and on its surface (Cowardin, December 1979). Wetlands are found from the tundra to the tropics and on every continent except Antarctica. Wetlands are areas that are inundated or saturated by surface or groundwater at a frequency and duration sufficient to support, and that under normal circumstances do support, a prevalence of vegetation typically adapted for life in saturated soil conditions. Wetlands generally include swamps, marshes, bogs and similar areas. Wetlands may be forested or unforested, and naturally or artificially created.');

-- --------------------------------------------------------

--
-- Table structure for table `sources`
--

DROP TABLE IF EXISTS `sources`;
CREATE TABLE IF NOT EXISTS `sources` (
  `SourceID` int(11) NOT NULL AUTO_INCREMENT,
  `Organization` varchar(255) NOT NULL,
  `SourceDescription` text NOT NULL,
  `SourceLink` text,
  `ContactName` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Phone` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Email` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Address` varchar(255) NOT NULL DEFAULT 'Unknown',
  `City` varchar(255) NOT NULL DEFAULT 'Unknown',
  `State` varchar(255) NOT NULL DEFAULT 'Unknown',
  `ZipCode` varchar(255) NOT NULL DEFAULT 'Unknown',
  `Citation` text NOT NULL,
  `MetadataID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`SourceID`),
  KEY `MetadataID` (`MetadataID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


--
-- Table structure for table `spatialreferences`
--

DROP TABLE IF EXISTS `spatialreferences`;
CREATE TABLE IF NOT EXISTS `spatialreferences` (
  `SpatialReferenceID` int(11) NOT NULL,
  `SRSID` int(11) DEFAULT NULL,
  `SRSName` varchar(255) NOT NULL,
  `IsGeographic` tinyint(1) DEFAULT NULL,
  `Notes` text,
  PRIMARY KEY (`SpatialReferenceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `spatialreferences`
--

INSERT INTO `spatialreferences` (`SpatialReferenceID`, `SRSID`, `SRSName`, `IsGeographic`, `Notes`) VALUES
(0, NULL, 'Unknown', 0, 'The spatial reference system is unknown'),
(1, 4267, 'NAD27', 1, NULL),
(2, 4269, 'NAD83', 1, NULL),
(3, 4326, 'WGS84', 1, NULL),
(4, 26703, 'NAD27 / UTM zone 3N', 0, NULL),
(5, 26704, 'NAD27 / UTM zone 4N', 0, NULL),
(6, 26705, 'NAD27 / UTM zone 5N', 0, NULL),
(7, 26706, 'NAD27 / UTM zone 6N', 0, NULL),
(8, 26707, 'NAD27 / UTM zone 7N', 0, NULL),
(9, 26708, 'NAD27 / UTM zone 8N', 0, NULL),
(10, 26709, 'NAD27 / UTM zone 9N', 0, NULL),
(11, 26710, 'NAD27 / UTM zone 10N', 0, NULL),
(12, 26711, 'NAD27 / UTM zone 11N', 0, NULL),
(13, 26712, 'NAD27 / UTM zone 12N', 0, NULL),
(14, 26713, 'NAD27 / UTM zone 13N', 0, NULL),
(15, 26714, 'NAD27 / UTM zone 14N', 0, NULL),
(16, 26715, 'NAD27 / UTM zone 15N', 0, NULL),
(17, 26716, 'NAD27 / UTM zone 16N', 0, NULL),
(18, 26717, 'NAD27 / UTM zone 17N', 0, NULL),
(19, 26718, 'NAD27 / UTM zone 18N', 0, NULL),
(20, 26719, 'NAD27 / UTM zone 19N', 0, NULL),
(21, 26720, 'NAD27 / UTM zone 20N', 0, NULL),
(22, 26721, 'NAD27 / UTM zone 21N', 0, NULL),
(23, 26722, 'NAD27 / UTM zone 22N', 0, NULL),
(24, 26729, 'NAD27 / Alabama East', 0, NULL),
(25, 26730, 'NAD27 / Alabama West', 0, NULL),
(26, 26732, 'NAD27 / Alaska zone 2', 0, NULL),
(27, 26733, 'NAD27 / Alaska zone 3', 0, NULL),
(28, 26734, 'NAD27 / Alaska zone 4', 0, NULL),
(29, 26735, 'NAD27 / Alaska zone 5', 0, NULL),
(30, 26736, 'NAD27 / Alaska zone 6', 0, NULL),
(31, 26737, 'NAD27 / Alaska zone 7', 0, NULL),
(32, 26738, 'NAD27 / Alaska zone 8', 0, NULL),
(33, 26739, 'NAD27 / Alaska zone 9', 0, NULL),
(34, 26740, 'NAD27 / Alaska zone 10', 0, NULL),
(35, 26741, 'NAD27 / California zone I', 0, NULL),
(36, 26742, 'NAD27 / California zone II', 0, NULL),
(37, 26743, 'NAD27 / California zone III', 0, NULL),
(38, 26744, 'NAD27 / California zone IV', 0, NULL),
(39, 26745, 'NAD27 / California zone V', 0, NULL),
(40, 26746, 'NAD27 / California zone VI', 0, NULL),
(41, 26747, 'NAD27 / California zone VII', 0, NULL),
(42, 26748, 'NAD27 / Arizona East', 0, NULL),
(43, 26749, 'NAD27 / Arizona Central', 0, NULL),
(44, 26750, 'NAD27 / Arizona West', 0, NULL),
(45, 26751, 'NAD27 / Arkansas North', 0, NULL),
(46, 26752, 'NAD27 / Arkansas South', 0, NULL),
(47, 26753, 'NAD27 / Colorado North', 0, NULL),
(48, 26754, 'NAD27 / Colorado Central', 0, NULL),
(49, 26755, 'NAD27 / Colorado South', 0, NULL),
(50, 26756, 'NAD27 / Connecticut', 0, NULL),
(51, 26757, 'NAD27 / Delaware', 0, NULL),
(52, 26758, 'NAD27 / Florida East', 0, NULL),
(53, 26759, 'NAD27 / Florida West', 0, NULL),
(54, 26760, 'NAD27 / Florida North', 0, NULL),
(55, 26761, 'NAD27 / Hawaii zone 1', 0, NULL),
(56, 26762, 'NAD27 / Hawaii zone 2', 0, NULL),
(57, 26763, 'NAD27 / Hawaii zone 3', 0, NULL),
(58, 26764, 'NAD27 / Hawaii zone 4', 0, NULL),
(59, 26765, 'NAD27 / Hawaii zone 5', 0, NULL),
(60, 26766, 'NAD27 / Georgia East', 0, NULL),
(61, 26767, 'NAD27 / Georgia West', 0, NULL),
(62, 26768, 'NAD27 / Idaho East', 0, NULL),
(63, 26769, 'NAD27 / Idaho Central', 0, NULL),
(64, 26770, 'NAD27 / Idaho West', 0, NULL),
(65, 26771, 'NAD27 / Illinois East', 0, NULL),
(66, 26772, 'NAD27 / Illinois West', 0, NULL),
(67, 26773, 'NAD27 / Indiana East', 0, NULL),
(68, 26774, 'NAD27 / Indiana West', 0, NULL),
(69, 26775, 'NAD27 / Iowa North', 0, NULL),
(70, 26776, 'NAD27 / Iowa South', 0, NULL),
(71, 26777, 'NAD27 / Kansas North', 0, NULL),
(72, 26778, 'NAD27 / Kansas South', 0, NULL),
(73, 26779, 'NAD27 / Kentucky North', 0, NULL),
(74, 26780, 'NAD27 / Kentucky South', 0, NULL),
(75, 26781, 'NAD27 / Louisiana North', 0, NULL),
(76, 26782, 'NAD27 / Louisiana South', 0, NULL),
(77, 26783, 'NAD27 / Maine East', 0, NULL),
(78, 26784, 'NAD27 / Maine West', 0, NULL),
(79, 26785, 'NAD27 / Maryland', 0, NULL),
(80, 26786, 'NAD27 / Massachusetts Mainland', 0, NULL),
(81, 26787, 'NAD27 / Massachusetts Island', 0, NULL),
(82, 26791, 'NAD27 / Minnesota North', 0, NULL),
(83, 26792, 'NAD27 / Minnesota Central', 0, NULL),
(84, 26793, 'NAD27 / Minnesota South', 0, NULL),
(85, 26794, 'NAD27 / Mississippi East', 0, NULL),
(86, 26795, 'NAD27 / Mississippi West', 0, NULL),
(87, 26796, 'NAD27 / Missouri East', 0, NULL),
(88, 26797, 'NAD27 / Missouri Central', 0, NULL),
(89, 26798, 'NAD27 / Missouri West', 0, NULL),
(90, 26801, 'NAD Michigan / Michigan East', 0, NULL),
(91, 26802, 'NAD Michigan / Michigan Old Central', 0, NULL),
(92, 26803, 'NAD Michigan / Michigan West', 0, NULL),
(93, 26811, 'NAD Michigan / Michigan North', 0, NULL),
(94, 26812, 'NAD Michigan / Michigan Central', 0, NULL),
(95, 26813, 'NAD Michigan / Michigan South', 0, NULL),
(96, 26903, 'NAD83 / UTM zone 3N', 0, NULL),
(97, 26904, 'NAD83 / UTM zone 4N', 0, NULL),
(98, 26905, 'NAD83 / UTM zone 5N', 0, NULL),
(99, 26906, 'NAD83 / UTM zone 6N', 0, NULL),
(100, 26907, 'NAD83 / UTM zone 7N', 0, NULL),
(101, 26908, 'NAD83 / UTM zone 8N', 0, NULL),
(102, 26909, 'NAD83 / UTM zone 9N', 0, NULL),
(103, 26910, 'NAD83 / UTM zone 10N', 0, NULL),
(104, 26911, 'NAD83 / UTM zone 11N', 0, NULL),
(105, 26912, 'NAD83 / UTM zone 12N', 0, NULL),
(106, 26913, 'NAD83 / UTM zone 13N', 0, NULL),
(107, 26914, 'NAD83 / UTM zone 14N', 0, NULL),
(108, 26915, 'NAD83 / UTM zone 15N', 0, NULL),
(109, 26916, 'NAD83 / UTM zone 16N', 0, NULL),
(110, 26917, 'NAD83 / UTM zone 17N', 0, NULL),
(111, 26918, 'NAD83 / UTM zone 18N', 0, NULL),
(112, 26919, 'NAD83 / UTM zone 19N', 0, NULL),
(113, 26920, 'NAD83 / UTM zone 20N', 0, NULL),
(114, 26921, 'NAD83 / UTM zone 21N', 0, NULL),
(115, 26922, 'NAD83 / UTM zone 22N', 0, NULL),
(116, 26923, 'NAD83 / UTM zone 23N', 0, NULL),
(117, 26929, 'NAD83 / Alabama East', 0, NULL),
(118, 26930, 'NAD83 / Alabama West', 0, NULL),
(119, 26932, 'NAD83 / Alaska zone 2', 0, NULL),
(120, 26933, 'NAD83 / Alaska zone 3', 0, NULL),
(121, 26934, 'NAD83 / Alaska zone 4', 0, NULL),
(122, 26935, 'NAD83 / Alaska zone 5', 0, NULL),
(123, 26936, 'NAD83 / Alaska zone 6', 0, NULL),
(124, 26937, 'NAD83 / Alaska zone 7', 0, NULL),
(125, 26938, 'NAD83 / Alaska zone 8', 0, NULL),
(126, 26939, 'NAD83 / Alaska zone 9', 0, NULL),
(127, 26940, 'NAD83 / Alaska zone 10', 0, NULL),
(128, 26941, 'NAD83 / California zone 1', 0, NULL),
(129, 26942, 'NAD83 / California zone 2', 0, NULL),
(130, 26943, 'NAD83 / California zone 3', 0, NULL),
(131, 26944, 'NAD83 / California zone 4', 0, NULL),
(132, 26945, 'NAD83 / California zone 5', 0, NULL),
(133, 26946, 'NAD83 / California zone 6', 0, NULL),
(134, 26948, 'NAD83 / Arizona East', 0, NULL),
(135, 26949, 'NAD83 / Arizona Central', 0, NULL),
(136, 26950, 'NAD83 / Arizona West', 0, NULL),
(137, 26951, 'NAD83 / Arkansas North', 0, NULL),
(138, 26952, 'NAD83 / Arkansas South', 0, NULL),
(139, 26953, 'NAD83 / Colorado North', 0, NULL),
(140, 26954, 'NAD83 / Colorado Central', 0, NULL),
(141, 26955, 'NAD83 / Colorado South', 0, NULL),
(142, 26956, 'NAD83 / Connecticut', 0, NULL),
(143, 26957, 'NAD83 / Delaware', 0, NULL),
(144, 26958, 'NAD83 / Florida East', 0, NULL),
(145, 26959, 'NAD83 / Florida West', 0, NULL),
(146, 26960, 'NAD83 / Florida North', 0, NULL),
(147, 26961, 'NAD83 / Hawaii zone 1', 0, NULL),
(148, 26962, 'NAD83 / Hawaii zone 2', 0, NULL),
(149, 26963, 'NAD83 / Hawaii zone 3', 0, NULL),
(150, 26964, 'NAD83 / Hawaii zone 4', 0, NULL),
(151, 26965, 'NAD83 / Hawaii zone 5', 0, NULL),
(152, 26966, 'NAD83 / Georgia East', 0, NULL),
(153, 26967, 'NAD83 / Georgia West', 0, NULL),
(154, 26968, 'NAD83 / Idaho East', 0, NULL),
(155, 26969, 'NAD83 / Idaho Central', 0, NULL),
(156, 26970, 'NAD83 / Idaho West', 0, NULL),
(157, 26971, 'NAD83 / Illinois East', 0, NULL),
(158, 26972, 'NAD83 / Illinois West', 0, NULL),
(159, 26973, 'NAD83 / Indiana East', 0, NULL),
(160, 26974, 'NAD83 / Indiana West', 0, NULL),
(161, 26975, 'NAD83 / Iowa North', 0, NULL),
(162, 26976, 'NAD83 / Iowa South', 0, NULL),
(163, 26977, 'NAD83 / Kansas North', 0, NULL),
(164, 26978, 'NAD83 / Kansas South', 0, NULL),
(165, 26979, 'NAD83 / Kentucky North', 0, NULL),
(166, 26980, 'NAD83 / Kentucky South', 0, NULL),
(167, 26981, 'NAD83 / Louisiana North', 0, NULL),
(168, 26982, 'NAD83 / Louisiana South', 0, NULL),
(169, 26983, 'NAD83 / Maine East', 0, NULL),
(170, 26984, 'NAD83 / Maine West', 0, NULL),
(171, 26985, 'NAD83 / Maryland', 0, NULL),
(172, 26986, 'NAD83 / Massachusetts Mainland', 0, NULL),
(173, 26987, 'NAD83 / Massachusetts Island', 0, NULL),
(174, 26988, 'NAD83 / Michigan North', 0, NULL),
(175, 26989, 'NAD83 / Michigan Central', 0, NULL),
(176, 26990, 'NAD83 / Michigan South', 0, NULL),
(177, 26991, 'NAD83 / Minnesota North', 0, NULL),
(178, 26992, 'NAD83 / Minnesota Central', 0, NULL),
(179, 26993, 'NAD83 / Minnesota South', 0, NULL),
(180, 26994, 'NAD83 / Mississippi East', 0, NULL),
(181, 26995, 'NAD83 / Mississippi West', 0, NULL),
(182, 26996, 'NAD83 / Missouri East', 0, NULL),
(183, 26997, 'NAD83 / Missouri Central', 0, NULL),
(184, 26998, 'NAD83 / Missouri West  ', 0, NULL),
(185, 4176, 'Australian Antarctic', 1, 'Datum Name: Australian Antarctic Datum 1998    Area of Use: Antarctica - Australian sector.    Datum Origin: No Data Available    Coord System: ellipsoidal    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(186, 4203, 'AGD84', 1, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - Queensland (Qld), South Australia (SA), Western Australia (WA).    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: ellipsoidal    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(187, 4283, 'GDA94', 1, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - Australian Capital Territory (ACT); New South Wales (NSW); Northern Territory (NT); Queensland (Qld); South Australia (SA); Tasmania (Tas); Western Australia (WA); Victoria (Vic).    Datum Origin: ITRF92 at epoch 1994.0    Coord System: ellipsoidal    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(188, 5711, 'Australian Height Datum', 0, 'Datum Name: Australian Height Datum    Area of Use: Australia - Australian Capital Territory (ACT); New South Wales (NSW); Northern Territory (NT); Queensland; South Australia (SA); Western Australia (WA); Victoria.    Datum Origin: MSL 1966-68 at 30 gauges around coast.    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG'),
(189, 5712, 'Australian Height Datum (Tasmania)', 0, 'Datum Name: Australian Height Datum (Tasmania)    Area of Use: Australia - Tasmania (Tas).    Datum Origin: MSL 1972 at Hobart and Burnie.    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG'),
(190, 5714, 'Mean Sea Level Height', 0, 'Datum Name: Mean Sea Level    Area of Use: World.    Datum Origin: No Data Available    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG'),
(191, 5715, 'Mean Sea Level Depth', 0, 'Datum Name: Mean Sea Level    Area of Use: World.    Datum Origin: No Data Available    Coord System: vertical    Ellipsoid Name: No Data Available    Data Source: EPSG'),
(192, 20348, 'AGD84 / AMG zone 48', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 102 and 108 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(193, 20349, 'AGD84 / AMG zone 49', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 108 and 114 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(194, 20350, 'AGD84 / AMG zone 50', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 114 and 120 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(195, 20351, 'AGD84 / AMG zone 51', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 120 and 126 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(196, 20352, 'AGD84 / AMG zone 52', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 126 and 132 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(197, 20353, 'AGD84 / AMG zone 53', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 132 and 138 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(198, 20354, 'AGD84 / AMG zone 54', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 138 and 144 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(199, 20355, 'AGD84 / AMG zone 55', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 144 and 150 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(200, 20356, 'AGD84 / AMG zone 56', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 150 and 156 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(201, 20357, 'AGD84 / AMG zone 57', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 156 and 162 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(202, 20358, 'AGD84 / AMG zone 58', 0, 'Datum Name: Australian Geodetic Datum 1984    Area of Use: Australia - between 162 and 168 deg East.    Datum Origin: Fundamental point: Johnson Memorial Cairn. Latitude: 25 deg 56 min 54.5515 sec S; Longitude: 133 deg 12 min 30.0771 sec E (of Greenwich).    Coord System: Cartesian    Ellipsoid Name: Australian National Spheroid    Data Source: EPSG'),
(203, 28348, 'GDA94 / MGA zone 48', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 102 and 108 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(204, 28349, 'GDA94 / MGA zone 49', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 108 and 114 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(205, 28350, 'GDA94 / MGA zone 50', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 114 and 120 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(206, 28351, 'GDA94 / MGA zone 51', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 120 and 126 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(207, 28352, 'GDA94 / MGA zone 52', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 126 and 132 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(208, 28353, 'GDA94 / MGA zone 53', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 132 and 138 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(209, 28354, 'GDA94 / MGA zone 54', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 138 and 144 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(210, 28355, 'GDA94 / MGA zone 55', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 144 and 150 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(211, 28356, 'GDA94 / MGA zone 56', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 150 and 156 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(212, 28357, 'GDA94 / MGA zone 57', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 156 and 162 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(213, 28358, 'GDA94 / MGA zone 58', 0, 'Datum Name: Geocentric Datum of Australia 1994    Area of Use: Australia - between 162 and 168 deg East.    Datum Origin: ITRF92 at epoch 1994.0    Coord System: Cartesian    Ellipsoid Name: GRS 1980    Data Source: EPSG'),
(214, 32748, 'WGS 84 / UTM zone 48S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 102 and 108 deg East; southern hemisphere. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(215, 32749, 'WGS 84 / UTM zone 49S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 108 and 114 deg East; southern hemisphere. Australia. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(216, 32750, 'WGS 84 / UTM zone 50S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 114 and 120 deg East; southern hemisphere. Australia. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(217, 32751, 'WGS 84 / UTM zone 51S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 120 and 126 deg East; southern hemisphere. Australia. East Timor. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(218, 32752, 'WGS 84 / UTM zone 52S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 126 and 132 deg East; southern hemisphere. Australia. East Timor. Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(219, 32753, 'WGS 84 / UTM zone 53S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 132 and 138 deg East; southern hemisphere. Australia.  Indonesia.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(220, 32754, 'WGS 84 / UTM zone 54S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 138 and 144 deg East; southern hemisphere. Australia. Indonesia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(221, 32755, 'WGS 84 / UTM zone 55S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 144 and 150 deg East; southern hemisphere. Australia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(222, 32756, 'WGS 84 / UTM zone 56S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 150 and 156 deg East; southern hemisphere. Australia. Papua New Guinea.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(223, 32757, 'WGS 84 / UTM zone 57S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 156 and 162 deg East; southern hemisphere.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(224, 32758, 'WGS 84 / UTM zone 58S', 0, 'Datum Name: World Geodetic System 1984    Area of Use: Between 162 and 168 deg East; southern hemisphere.    Datum Origin: Defined through a consistent set of station coordinates. These have changed with time: by 0.7m on 29/6/1994 [WGS 84 (G730)], a further 0.2m on 29/1/1997 [WGS 84 (G873)] and a further 0.06m on 20/1/2002 [WGS 84 (G1150)].    Coord System: Cartesian    Ellipsoid Name: WGS 84    Data Source: EPSG'),
(225, 3308, 'GDA94 / NSW Lambert', 0, 'Datum Name: Geocentric Datum of Australia 1994 Area of Use: Australia - New South Wales (NSW). Datum Origin: ITRF92 at epoch 1994.0  Ellipsoid Name: GRS 1980 Data Source: EPSG'),
(226, 2914, 'NAD_1983_HARN_StatePlane_Oregon_South_FIPS_3602_Feet_Intl', 0, 'I wonder if we can''t just load the entire list at:\nhttp://www.arcwebservices.com/v2006/help/index_Left.htm#StartTopic=support/pcs_name.htm#|SkinName=ArcWeb \ninto the CV??'),
(227, 2276, 'NAD83 / Texas North Central (ftUS)', 0, 'ESRI Name: NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet\nArea of Use: United States (USA) - Texas - counties of: Andrews; Archer; Bailey; Baylor; Borden; Bowie; Callahan; Camp; Cass; Clay; Cochran; Collin; Cooke; Cottle; Crosby; Dallas; Dawson; Delta; Denton; Dickens; Eastland; Ellis; Erath; Fannin; Fisher; Floyd; Foard; Franklin; Gaines; Garza; Grayson; Gregg; Hale; Hardeman; Harrison; Haskell; Henderson; Hill; Hockley; Hood; Hopkins; Howard; Hunt; Jack; Johnson; Jones; Kaufman; Kent; King; Knox; Lamar; Lamb; Lubbock; Lynn; Marion; Martin; Mitchell; Montague; Morris; Motley; Navarro; Nolan; Palo Pinto; Panola; Parker; Rains; Red River; Rockwall; Rusk; Scurry; Shackelford; Smith; Somervell; Stephens; Stonewall; Tarrant; Taylor; Terry; Throckmorton; Titus; Upshur; Van Zandt; Wichita; Wilbarger; Wise; Wood; Yoakum; Young.'),
(228, 0, 'HRAP Grid Coordinate System', 0, 'Datum Name: Hydrologic Rainfall Analysis Project (HRAP) grid coordinate system  Information: a polar stereographic projection true at 60');

-- --------------------------------------------------------

--
-- Table structure for table `speciationcv`
--

DROP TABLE IF EXISTS `speciationcv`;
CREATE TABLE IF NOT EXISTS `speciationcv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `speciationcv`
--

INSERT INTO `speciationcv` (`Term`, `Definition`) VALUES
('Al', 'Expressed as aluminium'),
('As', 'Expressed as arsenic'),
('B', 'Expressed as boron'),
('Ba', 'Expressed as barium'),
('Br', 'Expressed as bromine'),
('C', 'Expressed as carbon'),
('C2H6', 'Expressed as ethane'),
('Ca', 'Expressed as calcium'),
('CaCO3', 'Expressed as calcium carbonate'),
('Cd', 'Expressed as cadmium'),
('CH4', 'Expressed as methane'),
('Cl', 'Expressed as chlorine'),
('Co', 'Expressed as cobalt'),
('CO2', 'Expressed as carbon dioxide'),
('CO3', 'Expressed as carbonate'),
('Cr', 'Expressed as chromium'),
('Cu', 'Expressed as copper'),
('delta 2H', 'Expressed as deuterium'),
('delta N15', 'Expressed as nitrogen-15'),
('delta O18 ', 'Expressed as oxygen-18'),
('EC', 'Expressed as electrical conductivity'),
('F', 'Expressed as fluorine '),
('Fe', 'Expressed as iron'),
('H2O', 'Expressed as water'),
('HCO3', 'Expressed as hydrogen carbonate'),
('Hg', 'Expressed as mercury'),
('K', 'Expressed as potassium'),
('Mg', 'Expressed as magnesium'),
('Mn', 'Expressed as manganese'),
('Mo', 'Expressed as molybdenum'),
('N', 'Expressed as nitrogen'),
('Na', 'Expressed as sodium'),
('NH4', 'Expressed as ammonium'),
('Ni', 'Expressed as nickel'),
('NO2', 'Expressed as nitrite'),
('NO3', 'Expressed as nitrate'),
('Not Applicable', 'Speciation is not applicable'),
('P', 'Expressed as phosphorus'),
('Pb', 'Expressed as lead'),
('pH', 'Expressed as pH'),
('PO4', 'Expressed as phosphate'),
('S', 'Expressed as Sulfur'),
('Sb', 'Expressed as antimony'),
('Se', 'Expressed as selenium'),
('Si', 'Expressed as silicon'),
('SiO2', 'Expressed as silicate'),
('SN', 'Expressed as tin'),
('SO4', 'Expressed as Sulfate'),
('Sr', 'Expressed as strontium'),
('TA', 'Expressed as total alkalinity'),
('Ti', 'Expressed as titanium'),
('Tl', 'Expressed as thallium'),
('U', 'Expressed as uranium'),
('Unknown', 'Speciation is unknown'),
('V', 'Expressed as vanadium'),
('Zn', 'Expressed as zinc'),
('Zr', 'Expressed as zircon');

-- --------------------------------------------------------

--
-- Table structure for table `topiccategorycv`
--

DROP TABLE IF EXISTS `topiccategorycv`;
CREATE TABLE IF NOT EXISTS `topiccategorycv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `topiccategorycv`
--

INSERT INTO `topiccategorycv` (`Term`, `Definition`) VALUES
('biota', 'Data associated with biological organisms'),
('boundaries', 'Data associated with boundaries'),
('climatology/meteorology/atmosphere', 'Data associated with climatology, meteorology, or the atmosphere'),
('economy', 'Data associated with the economy'),
('elevation', 'Data associated with elevation'),
('environment', 'Data associated with the environment'),
('farming', 'Data associated with agricultural production'),
('geoscientificInformation', 'Data associated with geoscientific information'),
('health', 'Data associated with health'),
('imageryBaseMapsEarthCover', 'Data associated with imagery, base maps, or earth cover'),
('inlandWaters', 'Data associated with inland waters'),
('intelligenceMilitary', 'Data associated with intelligence or the military'),
('location', 'Data associated with location'),
('oceans', 'Data associated with oceans'),
('planningCadastre', 'Data associated with planning or cadestre'),
('society', 'Data associated with society'),
('structure', 'Data associated with structure'),
('transportation', 'Data associated with transportation'),
('Unknown', 'The topic category is unknown'),
('utilitiesCommunication', 'Data associated with utilities or communication');

-- --------------------------------------------------------

--
-- Table structure for table `units`
--

DROP TABLE IF EXISTS `units`;
CREATE TABLE IF NOT EXISTS `units` (
  `unitsID` int(11) NOT NULL AUTO_INCREMENT,
  `unitsName` varchar(255) NOT NULL,
  `unitsType` varchar(255) NOT NULL,
  `unitsAbbreviation` varchar(255) NOT NULL,
  PRIMARY KEY (`unitsID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=349 ;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`unitsID`, `unitsName`, `unitsType`, `unitsAbbreviation`) VALUES
(1, 'percent', 'Dimensionless', '%'),
(2, 'degree', 'Angle', 'deg'),
(3, 'grad', 'Angle', 'grad'),
(4, 'radian', 'Angle', 'rad'),
(5, 'degree north', 'Angle', 'degN'),
(6, 'degree south', 'Angle', 'degS'),
(7, 'degree west', 'Angle', 'degW'),
(8, 'degree east', 'Angle', 'degE'),
(9, 'arcminute', 'Angle', 'arcmin'),
(10, 'arcsecond', 'Angle', 'arcsec'),
(11, 'steradian', 'Angle', 'sr'),
(12, 'acre', 'Area', 'ac'),
(13, 'hectare', 'Area', 'ha'),
(14, 'square centimeter', 'Area', 'cm^2'),
(15, 'square foot', 'Area', 'ft^2'),
(16, 'square kilometer', 'Area', 'km^2'),
(17, 'square meter', 'Area', 'm^2'),
(18, 'square mile', 'Area', 'mi^2'),
(19, 'hertz', 'Frequency', 'Hz'),
(20, 'darcy', 'Permeability', 'D'),
(21, 'british thermal unit', 'Energy', 'BTU'),
(22, 'calorie', 'Energy', 'cal'),
(23, 'erg', 'Energy', 'erg'),
(24, 'foot pound force', 'Energy', 'lbf ft'),
(25, 'joule', 'Energy', 'J'),
(26, 'kilowatt hour', 'Energy', 'kW hr'),
(27, 'electronvolt', 'Energy', 'eV'),
(28, 'langleys per day', 'Energy Flux', 'Ly/d'),
(29, 'langleys per minute', 'Energy Flux', 'Ly/min'),
(30, 'langleys per second', 'Energy Flux', 'Ly/s'),
(31, 'megajoules per square meter per day', 'Energy Flux', 'MJ/m^2 d'),
(32, 'watts per square centimeter', 'Energy Flux', 'W/cm^2'),
(33, 'watts per square meter', 'Energy Flux', 'W/m^2'),
(34, 'acre feet per year', 'Flow', 'ac ft/yr'),
(35, 'cubic feet per second', 'Flow', 'cfs'),
(36, 'cubic meters per second', 'Flow', 'm^3/s'),
(37, 'cubic meters per day', 'Flow', 'm^3/d'),
(38, 'gallons per minute', 'Flow', 'gpm'),
(39, 'liters per second', 'Flow', 'L/s'),
(40, 'million gallons per day', 'Flow', 'MGD'),
(41, 'dyne', 'Force', 'dyn'),
(42, 'kilogram force', 'Force', 'kgf'),
(43, 'newton', 'Force', 'N'),
(44, 'pound force', 'Force', 'lbf'),
(45, 'kilo pound force', 'Force', 'kip'),
(46, 'ounce force', 'Force', 'ozf'),
(47, 'centimeter   ', 'Length', 'cm'),
(48, 'international foot', 'Length', 'ft'),
(49, 'international inch', 'Length', 'in'),
(50, 'international yard', 'Length', 'yd'),
(51, 'kilometer', 'Length', 'km'),
(52, 'meter', 'Length', 'm'),
(53, 'international mile', 'Length', 'mi'),
(54, 'millimeter', 'Length', 'mm'),
(55, 'micron', 'Length', 'um'),
(56, 'angstrom', 'Length', ''),
(57, 'femtometer', 'Length', 'fm'),
(58, 'nautical mile', 'Length', 'nmi'),
(59, 'lumen', 'Light', 'lm'),
(60, 'lux', 'Light', 'lx'),
(61, 'lambert', 'Light', 'La'),
(62, 'stilb', 'Light', 'sb'),
(63, 'phot', 'Light', 'ph'),
(64, 'langley', 'Light', 'Ly'),
(65, 'gram', 'Mass', 'g'),
(66, 'kilogram', 'Mass', 'kg'),
(67, 'milligram', 'Mass', 'mg'),
(68, 'microgram', 'Mass', 'ug'),
(69, 'pound mass (avoirdupois)', 'Mass', 'lb'),
(70, 'slug', 'Mass', 'slug'),
(71, 'metric ton', 'Mass', 'tonne'),
(72, 'grain', 'Mass', 'grain'),
(73, 'carat', 'Mass', 'car'),
(74, 'atomic mass unit', 'Mass', 'amu'),
(75, 'short ton', 'Mass', 'ton'),
(76, 'BTU per hour', 'Power', 'BTU/hr'),
(77, 'foot pound force per second', 'Power', 'lbf/s'),
(78, 'horse power (shaft)', 'Power', 'hp'),
(79, 'kilowatt', 'Power', 'kW'),
(80, 'watt', 'Power', 'W'),
(81, 'voltampere', 'Power', 'VA'),
(82, 'atmospheres', 'Pressure/Stress', 'atm'),
(83, 'pascal', 'Pressure/Stress', 'Pa'),
(84, 'inch of mercury', 'Pressure/Stress', 'inch Hg'),
(85, 'inch of water', 'Pressure/Stress', 'inch H2O'),
(86, 'millimeter of mercury', 'Pressure/Stress', 'mm Hg'),
(87, 'millimeter of water', 'Pressure/Stress', 'mm H2O'),
(88, 'centimeter of mercury', 'Pressure/Stress', 'cm Hg'),
(89, 'centimeter of water', 'Pressure/Stress', 'cm H2O'),
(90, 'millibar', 'Pressure/Stress', 'mbar'),
(91, 'pound force per square inch', 'Pressure/Stress', 'psi'),
(92, 'torr', 'Pressure/Stress', 'torr'),
(93, 'barie', 'Pressure/Stress', 'barie'),
(94, 'meters per pixel', 'Resolution', 'meters per pixel'),
(95, 'meters per meter', 'Scale', '-'),
(96, 'degree celsius', 'Temperature', 'degC'),
(97, 'degree fahrenheit', 'Temperature', 'degF'),
(98, 'degree rankine', 'Temperature', 'degR'),
(99, 'degree kelvin', 'Temperature', 'degK'),
(100, 'second', 'Time', 's'),
(101, 'millisecond', 'Time', 'millisec'),
(102, 'minute', 'Time', 'min'),
(103, 'hour', 'Time', 'hr'),
(104, 'day', 'Time', 'd'),
(105, 'week', 'Time', 'week'),
(106, 'month', 'Time', 'month'),
(107, 'common year (365 days)', 'Time', 'yr'),
(108, 'leap year (366 days)', 'Time', 'leap yr'),
(109, 'Julian year (365.25 days)', 'Time', 'jul yr'),
(110, 'Gregorian year (365.2425 days)', 'Time', 'greg yr'),
(111, 'centimeters per hour', 'Velocity', 'cm/hr'),
(112, 'centimeters per second', 'Velocity', 'cm/s'),
(113, 'feet per second', 'Velocity', 'ft/s'),
(114, 'gallons per day per square foot', 'Velocity', 'gpd/ft^2'),
(115, 'inches per hour', 'Velocity', 'in/hr'),
(116, 'kilometers per hour', 'Velocity', 'km/h'),
(117, 'meters per day', 'Velocity', 'm/d'),
(118, 'meters per hour', 'Velocity', 'm/hr'),
(119, 'meters per second', 'Velocity', 'm/s'),
(120, 'miles per hour', 'Velocity', 'mph'),
(121, 'millimeters per hour', 'Velocity', 'mm/hr'),
(122, 'nautical mile per hour', 'Velocity', 'knot'),
(123, 'acre foot', 'Volume', 'ac ft'),
(124, 'cubic centimeter', 'Volume', 'cc'),
(125, 'cubic foot', 'Volume', 'ft^3'),
(126, 'cubic meter', 'Volume', 'm^3'),
(127, 'hectare meter', 'Volume', 'hec m'),
(128, 'liter', 'Volume', 'L'),
(129, 'US gallon', 'Volume', 'gal'),
(130, 'barrel', 'Volume', 'bbl'),
(131, 'pint', 'Volume', 'pt'),
(132, 'bushel', 'Volume', 'bu'),
(133, 'teaspoon', 'Volume', 'tsp'),
(134, 'tablespoon', 'Volume', 'tbsp'),
(135, 'quart', 'Volume', 'qrt'),
(136, 'ounce', 'Volume', 'oz'),
(137, 'dimensionless', 'Dimensionless', '-'),
(138, 'mega joule', 'Energy', 'MJ'),
(139, 'degrees minutes seconds', 'Angle', 'dddmmss'),
(140, 'calories per square centimeter per day', 'Energy Flux', 'cal/cm^2 d'),
(141, 'calories per square centimeter per minute', 'Energy Flux', 'cal/cm^2 min'),
(142, 'milliliters per square centimeter per day', 'Hyporheic flux', 'ml/cm^2 d'),
(144, 'megajoules per square meter', 'Energy per Area', 'MJ/m^2'),
(145, 'gallons per day', 'Flow', 'gpd'),
(146, 'million gallons per month', 'Flow', 'MGM'),
(147, 'million gallons per year', 'Flow', 'MGY'),
(148, 'short tons per day per foot', 'Mass flow per unit width', 'ton/d ft'),
(149, 'lumens per square foot', 'Light Intensity', 'lm/ft^2'),
(150, 'microeinsteins per square meter per second', 'Light Intensity', 'uE/m^2 s'),
(151, 'alphas per meter', 'Light', 'a/m'),
(152, 'microeinsteins per square meter', 'Light', 'uE/m^2'),
(153, 'millimoles of photons per square meter', 'Light', 'mmol/m^2'),
(154, 'absorbance per centimeter', 'Extinction/Absorbance', 'A/cm'),
(155, 'nanogram', 'Mass', 'ng'),
(156, 'picogram', 'Mass', 'pg'),
(157, 'milliequivalents', 'Mass', 'meq'),
(158, 'grams per square meter', 'Areal Density', 'g/m^2'),
(159, 'milligrams per square meter', 'Areal Density', 'mg/m^2'),
(160, 'micrograms per square meter', 'Areal Density', 'ug/m^2'),
(161, 'grams per square meter per day', 'Areal Loading', 'g/m^2 d'),
(162, 'grams per day', 'Loading', 'g/d'),
(163, 'pounds per day', 'Loading', 'lb/d'),
(164, 'pounds per mile', 'Loading', 'lb/mi'),
(165, 'short tons per day', 'Loading', 'ton/d'),
(166, 'milligrams per cubic meter per day', 'Productivity', 'mg/m^3 d'),
(167, 'milligrams per square meter per day', 'Productivity', 'mg/m^2 d'),
(168, 'volts', 'Potential Difference', 'V'),
(169, 'millivolts', 'Potential Difference', 'mV'),
(170, 'kilopascal', 'Pressure/Stress', 'kPa'),
(171, 'megapascal', 'Pressure/Stress', 'MPa'),
(172, 'becquerel', 'Radioactivity', 'Bq'),
(173, 'becquerels per gram', 'Radioactivity', 'Bq/g'),
(174, 'curie', 'Radioactivity', 'Ci'),
(175, 'picocurie', 'Radioactivity', 'pCi'),
(176, 'ohm', 'Resistance', 'ohm'),
(177, 'ohm meter', 'Resistivity', 'ohm m'),
(178, 'picocuries per gram', 'Specific Activity', 'pCi/g'),
(179, 'picocuries per liter', 'Specific Activity', 'pCi/L'),
(180, 'picocuries per milliliter', 'Specific Activity', 'pCi/ml'),
(181, 'hour minute', 'Time', 'hhmm'),
(182, 'year month day', 'Time', 'yymmdd'),
(183, 'year day (Julian)', 'Time', 'yyddd'),
(184, 'inches per day', 'Velocity', 'in/d'),
(185, 'inches per week', 'Velocity', 'in/week'),
(186, 'inches per storm', 'Precipitation', 'in/storm'),
(187, 'thousand acre feet', 'Volume', '10^3 ac ft'),
(188, 'milliliter', 'Volume', 'ml'),
(189, 'cubic feet per second days', 'Volume', 'cfs d'),
(190, 'thousand gallons', 'Volume', '10^3 gal'),
(191, 'million gallons', 'Volume', '10^6 gal'),
(192, 'microsiemens per centimeter', 'Electrical Conductivity', 'uS/cm'),
(193, 'practical salinity units ', 'Salinity', 'psu'),
(194, 'decibel', 'Sound', 'dB'),
(195, 'cubic centimeters per gram', 'Specific Volume', 'cm^3/g'),
(196, 'square meters per gram', 'Specific Surface Area ', 'm^2/g'),
(197, 'short tons per acre foot', 'Concentration', 'ton/ac ft'),
(198, 'grams per cubic centimeter', 'Concentration', 'g/cm^3'),
(199, 'milligrams per liter', 'Concentration', 'mg/L'),
(200, 'nanograms per cubic meter', 'Concentration', 'ng/m^3'),
(201, 'nanograms per liter', 'Concentration', 'ng/L'),
(202, 'grams per liter', 'Concentration', 'g/L'),
(203, 'micrograms per cubic meter', 'Concentration', 'ug/m^3'),
(204, 'micrograms per liter', 'Concentration', 'ug/L'),
(205, 'parts per million', 'Concentration', 'ppm'),
(206, 'parts per billion', 'Concentration', 'ppb'),
(207, 'parts per trillion', 'Concentration', 'ppt'),
(208, 'parts per quintillion', 'Concentration', 'ppqt'),
(209, 'parts per quadrillion', 'Concentration', 'ppq'),
(210, 'per mille', 'Concentration', '%o'),
(211, 'microequivalents per liter', 'Concentration', 'ueq/L'),
(212, 'milliequivalents per liter', 'Concentration', 'meq/L'),
(213, 'milliequivalents per 100 gram', 'Concentration', 'meq/100 g'),
(214, 'milliosmols per kilogram', 'Concentration', 'mOsm/kg'),
(215, 'nanomoles per liter', 'Concentration', 'nmol/L'),
(216, 'picograms per cubic meter', 'Concentration', 'pg/m^3'),
(217, 'picograms per liter', 'Concentration', 'pg/L'),
(218, 'picograms per milliliter', 'Concentration', 'pg/ml'),
(219, 'tritium units', 'Concentration', 'TU'),
(220, 'jackson turbidity units', 'Turbidity', 'JTU'),
(221, 'nephelometric turbidity units', 'Turbidity', 'NTU'),
(222, 'nephelometric turbidity multibeam unit', 'Turbidity', 'NTMU'),
(223, 'nephelometric turbidity ratio unit', 'Turbidity', 'NTRU'),
(224, 'formazin nephelometric multibeam unit', 'Turbidity', 'FNMU'),
(225, 'formazin nephelometric ratio unit', 'Turbidity', 'FNRU'),
(226, 'formazin nephelometric unit', 'Turbidity', 'FNU'),
(227, 'formazin attenuation unit', 'Turbidity', 'FAU'),
(228, 'formazin backscatter unit ', 'Turbidity', 'FBU'),
(229, 'backscatter units', 'Turbidity', 'BU'),
(230, 'attenuation units', 'Turbidity', 'AU'),
(231, 'platinum cobalt units', 'Color', 'PCU'),
(232, 'the ratio between UV absorbance at 254 nm and DOC level', 'Specific UV Absorbance', 'L/(mg DOC/cm)'),
(233, 'billion colonies per day', 'Organism Loading', '10^9 colonies/d'),
(234, 'number of organisms per square meter', 'Organism Concentration', '#/m^2'),
(235, 'number of organisms per liter', 'Organism Concentration', '#/L'),
(236, 'number or organisms per cubic meter', 'Organism Concentration', '#/m^3'),
(237, 'cells per milliliter', 'Organism Concentration', 'cells/ml'),
(238, 'cells per square millimeter', 'Organism Concentration', 'cells/mm^2'),
(239, 'colonies per 100 milliliters', 'Organism Concentration', 'colonies/100 ml'),
(240, 'colonies per milliliter', 'Organism Concentration', 'colonies/ml'),
(241, 'colonies per gram', 'Organism Concentration', 'colonies/g'),
(242, 'colony forming units per milliliter', 'Organism Concentration', 'CFU/ml'),
(243, 'cysts per 10 liters', 'Organism Concentration', 'cysts/10 L'),
(244, 'cysts per 100 liters', 'Organism Concentration', 'cysts/100 L'),
(245, 'oocysts per 10 liters', 'Organism Concentration', 'oocysts/10 L'),
(246, 'oocysts per 100 liters', 'Organism Concentration', 'oocysts/100 L'),
(247, 'most probable number', 'Organism Concentration', 'MPN'),
(248, 'most probable number per 100 liters', 'Organism Concentration', 'MPN/100 L'),
(249, 'most probable number per 100 milliliters', 'Organism Concentration', 'MPN/100 ml'),
(250, 'most probable number per gram', 'Organism Concentration', 'MPN/g'),
(251, 'plaque-forming units per 100 liters', 'Organism Concentration', 'PFU/100 L'),
(252, 'plaques per 100 milliliters', 'Organism Concentration', 'plaques/100 ml'),
(253, 'counts per second', 'Rate', '#/s'),
(254, 'per day', 'Rate', '1/d'),
(255, 'nanograms per square meter per hour', 'Volatilization Rate', 'ng/m^2 hr'),
(256, 'nanograms per square meter per week', 'Volatilization Rate', 'ng/m^2 week'),
(257, 'count', 'Dimensionless', '#'),
(258, 'categorical', 'Dimensionless', 'code'),
(259, 'absorbance per centimeter per mg/L of given acid ', 'Absorbance', '100/cm mg/L'),
(260, 'per liter', 'Concentration Ratio', '1/L'),
(261, 'per mille per hour', 'Sedimentation Rate', '%o/hr'),
(262, 'gallons per batch', 'Flow', 'gpb'),
(263, 'cubic feet per barrel', 'Concentration', 'ft^3/bbl'),
(264, 'per mille by volume', 'Concentration', '%o by vol'),
(265, 'per mille per hour by volume', 'Sedimentation Rate', '%o/hr by vol'),
(266, 'micromoles', 'Amount', 'umol'),
(267, 'tons of calcium carbonate per kiloton', 'Net Neutralization Potential', 'tCaCO3/Kt'),
(268, 'siemens per meter', 'Electrical Conductivity', 'S/m'),
(269, 'millisiemens per centimeter', 'Electrical Conductivity', 'mS/cm'),
(270, 'siemens per centimeter', 'Electrical Conductivity', 'S/cm'),
(271, 'practical salinity scale', 'Salinity', 'pss'),
(272, 'per meter', 'Light Extinction', '1/m'),
(273, 'normal', 'Normality', 'N'),
(274, 'nanomoles per kilogram', 'Concentration', 'nmol/kg'),
(275, 'millimoles per kilogram', 'Concentration', 'mmol/kg'),
(276, 'millimoles per square meter per hour', 'Areal Flux', 'mmol/m^2 hr'),
(277, 'milligrams per cubic meter per hour', 'Productivity', 'mg/m^3 hr'),
(278, 'milligrams per day', 'Loading', 'mg/d'),
(279, 'liters per minute', 'Flow', 'L/min'),
(280, 'liters per day', 'Flow', 'L/d'),
(281, 'jackson candle units ', 'Turbidity', 'JCU'),
(282, 'grains per gallon', 'Concentration', 'gpg'),
(283, 'gallons per second', 'Flow', 'gps'),
(284, 'gallons per hour', 'Flow', 'gph'),
(285, 'foot candle', 'Illuminance', 'ftc'),
(286, 'fibers per liter', 'Concentration', 'fibers/L'),
(287, 'drips per minute', 'Flow', 'drips/min'),
(288, 'cubic centimeters per second', 'Flow', 'cm^3/sec'),
(289, 'colony forming units', 'Organism Concentration', 'CFU'),
(290, 'colony forming units per 100 milliliter', 'Organism Concentration', 'CFU/100 ml'),
(291, 'cubic feet per minute', 'Flow', 'cfm'),
(292, 'ADMI color unit', 'Color', 'ADMI'),
(293, 'percent by volume', 'Concentration', '% by vol'),
(294, 'number of organisms per 500 milliliter', 'Organism Concentration', '#/500 ml'),
(295, 'number of organisms per 100 gallon', 'Organism Concentration', '#/100 gal'),
(296, 'grams per cubic meter per hour', 'Productivity', 'g/m^3 hr'),
(297, 'grams per minute', 'Loading', 'g/min'),
(298, 'grams per second', 'Loading', 'g/s'),
(299, 'million cubic feet', 'Volume', '10^6 ft^3'),
(300, 'month year', 'Time', 'mmyy'),
(301, 'bar', 'Pressure', 'bar'),
(302, 'decisiemens per centimeter', 'Electrical Conductivity', 'dS/cm'),
(303, 'micromoles per liter', 'Concentration', 'umol/L'),
(304, 'Joules per square centimeter', 'Energy per Area', 'J/cm^2'),
(305, 'millimeters per day', 'velocity', 'mm/day'),
(306, 'parts per thousand', 'Concentration', 'ppth'),
(307, 'megaliter', 'Volume', 'ML'),
(308, 'Percent Saturation', 'Concentration', '% Sat'),
(309, 'pH Unit', 'Dimensionless', 'pH'),
(310, 'millimeters per second', 'Velocity', 'mm/s'),
(311, 'liters per hour', 'Flow', 'L/hr'),
(312, 'cubic hecto meter', 'Volume', '(hm)^3'),
(313, 'mols per cubic meter', 'Concentration or organism concentration', 'mol/m^3'),
(314, 'kilo grams per month', 'Loading', 'kg/month'),
(315, 'Hecto Pascal', 'Pressure/Stress', 'hPa'),
(316, 'kilo grams per cubic meter', 'Concentration', 'kg/m^3'),
(317, 'short tons per month', 'Loading', 'ton/month'),
(318, 'micromoles per square meter per second', 'Areal Flux', 'umol/m^2 s'),
(319, 'grams per square meter per hour', 'Areal Flux', 'g/m^2 hr'),
(320, 'milligrams per cubic meter', 'Concentration', 'mg/m^3'),
(321, 'meters squared per second squared', 'Velocity', 'm^2/s^2'),
(322, 'squared degree Celsius', 'Temperature', '(DegC)^2'),
(323, 'milligrams per cubic meter squared', 'Concentration', '(mg/m^3)^2'),
(324, 'meters per second degree Celsius', 'Temperature', 'm/s DegC'),
(325, 'millimoles per square meter per second', 'Areal Flux', 'mmol/m^2 s'),
(326, 'degree Celsius millimoles per cubic meter', 'Concentration', 'DegC mmol/m^3'),
(327, 'millimoles per cubic meter', 'Concentration', 'mmol/m^3'),
(328, 'millimoles per cubic meter squared', 'Concentration', '(mmol/m^3)^2'),
(329, 'Langleys per hour', 'Energy Flux', 'Ly/hr'),
(330, 'hits per square centimeter', 'Precipitation', 'hits/cm^2'),
(331, 'hits per square centimeter per hour', 'Velocity', 'hits/cm^2 hr'),
(332, 'relative fluorescence units', 'Fluorescence', 'RFU'),
(333, 'kilograms per hectare per day', 'Areal Flux', 'kg/ha d'),
(334, 'kilowatts per square meter', 'Energy Flux', 'kW/m^2'),
(335, 'kilograms per square meter', 'Areal Density', 'kg/m^2'),
(336, 'microeinsteins per square meter per day', 'Light Intensity', 'uE/m^2 d'),
(337, 'microgram per milliliter', 'Concentration', 'ug/mL'),
(338, 'Newton per square meter', 'Pressure/Stress', 'Newton/m^2'),
(339, 'micromoles per liter per hour', 'Pressure/Stress', 'umol/L hr'),
(340, 'decisiemens per meter', 'Electrical Conductivity', 'dS/m'),
(341, 'milligrams per kilogram', 'Mass Fraction', 'mg/Kg'),
(342, 'number of organisms per 100 milliliter', 'Organism Concentration', '#/100 mL'),
(343, 'micrograms per kilogram', 'Mass Fraction', 'ug/Kg'),
(344, 'grams per kilogram', 'Mass Fraction', 'g/Kg'),
(345, 'acre feet per month', 'Flow', 'ac ft/mo'),
(346, 'acre feet per half month', 'Flow', 'ac ft/0.5 mo'),
(347, 'cubic meters per minute', 'Flow', 'm^3/min'),
(348, 'count per half cubic foot', 'Concentration', '#/((ft^3)/2)');

-- --------------------------------------------------------

--
-- Table structure for table `valuetypecv`
--

DROP TABLE IF EXISTS `valuetypecv`;
CREATE TABLE IF NOT EXISTS `valuetypecv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `valuetypecv`
--

INSERT INTO `valuetypecv` (`Term`, `Definition`) VALUES
('Calibration Value', 'A value used as part of the calibration of an instrument at a particular time.'),
('Derived Value', 'Value that is directly derived from an observation or set of observations'),
('Field Observation', 'Observation of a variable using a field instrument'),
('Model Simulation Result', 'Values generated by a simulation model'),
('Sample', 'Observation that is the result of analyzing a sample in a laboratory'),
('Unknown', 'The value type is unknown');

-- --------------------------------------------------------

--
-- Table structure for table `variablenamecv`
--

DROP TABLE IF EXISTS `variablenamecv`;
CREATE TABLE IF NOT EXISTS `variablenamecv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `variablenamecv`
--

INSERT INTO `variablenamecv` (`Term`, `Definition`) VALUES
('19-Hexanoyloxyfucoxanthin', 'The phytoplankton pigment 19-Hexanoyloxyfucoxanthin'),
('9 cis-Neoxanthin', 'The phytoplankton pigment '),
('Acid neutralizing capacity', 'Acid neutralizing capacity '),
('Agency code', 'Code for the agency which analyzed the sample'),
('Albedo', 'The ratio of reflected to incident light.'),
('Alkalinity, bicarbonate', 'Bicarbonate Alkalinity '),
('Alkalinity, carbonate ', 'Carbonate Alkalinity '),
('Alkalinity, carbonate plus bicarbonate', 'Alkalinity, carbonate plus bicarbonate'),
('Alkalinity, hydroxide ', 'Hydroxide Alkalinity '),
('Alkalinity, total ', 'Total Alkalinity'),
('Alloxanthin', 'The phytoplankton pigment Alloxanthin'),
('Aluminium', 'Aluminium (Al)'),
('Aluminum, dissolved', 'Dissolved Aluminum (Al)'),
('Ammonium flux', 'Ammonium (NH4) flux'),
('Antimony', 'Antimony (Sb)'),
('Area', 'Area of a measurement location'),
('Arsenic', 'Arsenic (As)'),
('Asteridae coverage', 'Areal coverage of the plant Asteridae'),
('Barium, dissolved', 'Dissolved Barium (Ba)'),
('Barium, total', 'Total Barium (Ba)'),
('Barometric pressure', 'Barometric pressure'),
('Baseflow', 'The portion of streamflow (discharge) that is supplied by groundwater sources.'),
('Batis maritima Coverage', 'Areal coverage of the plant Batis maritima'),
('Battery Temperature', 'The battery temperature of a datalogger or sensing system'),
('Battery voltage', 'The battery voltage of a datalogger or sensing system, often recorded as an indicator of data reliability'),
('Benthos', 'Benthic species'),
('Bicarbonate', 'Bicarbonate (HCO3-)'),
('Biogenic silica', 'Hydrated silica (SiO2 nH20)'),
('Biomass, phytoplankton', 'Total mass of phytoplankton, per unit area or volume'),
('Biomass, total', 'Total biomass'),
('Blue-green algae (cyanobacteria), phycocyanin', 'Blue-green algae (cyanobacteria) with phycocyanin pigments'),
('BOD1', '1-day Biochemical Oxygen Demand'),
('BOD2, carbonaceous', '2-day Carbonaceous Biochemical Oxygen Demand'),
('BOD20', '20-day Biochemical Oxygen Demand'),
('BOD20, carbonaceous', '20-day Carbonaceous Biochemical Oxygen Demand'),
('BOD20, nitrogenous', '20-day Nitrogenous Biochemical Oxygen Demand'),
('BOD3, carbonaceous', '3-day Carbonaceous Biochemical Oxygen Demand'),
('BOD4, carbonaceous', '4-day Carbonaceous Biological Oxygen Demand'),
('BOD5', '5-day Biochemical Oxygen Demand'),
('BOD5, carbonaceous', '5-day Carbonaceous Biochemical Oxygen Demand'),
('BOD5, nitrogenous', '5-day Nitrogenous Biochemical Oxygen Demand'),
('BOD6, carbonaceous', '6-day Carbonaceous Biological Oxygen Demand'),
('BOD7, carbonaceous', '7-day Carbonaceous Biochemical Oxygen Demand'),
('BODu', 'Ultimate Biochemical Oxygen Demand'),
('BODu, carbonaceous', 'Carbonaceous Ultimate Biochemical Oxygen Demand'),
('BODu, nitrogenous', 'Nitrogenous Ultimate Biochemical Oxygen Demand'),
('Borehole log material classification', 'Classification of material encountered by a driller at various depths during the drilling of a well and recorded in the borehole log.'),
('Boron', 'Boron (B)'),
('Borrichia frutescens Coverage', 'Areal coverage of the plant Borrichia frutescens'),
('Bromide', 'Bromide'),
('Bromine', 'Bromine (Br)'),
('Bromine, dissolved', 'Dissolved Bromine (Br)'),
('Bulk electrical conductivity', 'Bulk electrical conductivity of a medium measured using a sensor such as time domain reflectometry (TDR), as a raw sensor response in the measurement of a quantity like soil moisture.'),
('Cadmium', 'Cadmium (Cd)'),
('Calcium ', 'Calcium (Ca) '),
('Calcium, dissolved', 'Dissolved Calcium (Ca)'),
('Canthaxanthin', 'The phytoplankton pigment Canthaxanthin'),
('Carbon dioxide', 'Carbon dioxide'),
('Carbon dioxide Flux', 'Carbon dioxide (CO2) flux'),
('Carbon dioxide Storage Flux', 'Carbon dioxide (CO2) storage flux'),
('Carbon dioxide, transducer signal', 'Carbon dioxide (CO2), raw data from sensor'),
('Carbon disulfide', 'Carbon disulfide (CS2)'),
('Carbon tetrachloride', 'Carbon tetrachloride (CCl4)'),
('Carbon to Nitrogen molar ratio', 'C:N (molar)'),
('Carbon, dissolved inorganic', 'Dissolved Inorganic Carbon'),
('Carbon, dissolved organic', 'Dissolved Organic Carbon'),
('Carbon, dissolved total', 'Dissolved Total (Organic+Inorganic) Carbon'),
('Carbon, particulate organic', 'Particulate organic carbon in suspension'),
('Carbon, suspended inorganic', 'Suspended Inorganic Carbon'),
('Carbon, suspended organic', 'DEPRECATED -- The use of this term is discouraged in favor of the use of the synonymous term "Carbon, particulate organic".'),
('Carbon, suspened total', 'Suspended Total (Organic+Inorganic) Carbon'),
('Carbon, total', 'Total (Dissolved+Particulate) Carbon'),
('Carbon, total inorganic', 'Total (Dissolved+Particulate) Inorganic Carbon'),
('Carbon, total organic', 'Total (Dissolved+Particulate) Organic Carbon'),
('Carbon, total solid phase', 'Total solid phase carbon'),
('Carbonate', 'Carbonate ion (CO3-2) concentration'),
('Chloride', 'Chloride (Cl-)'),
('Chloride, total', 'Total Chloride (Cl-)'),
('Chlorine', 'Chlorine (Cl)'),
('Chlorine, dissolved', 'Dissolved Chlorine (Cl)'),
('Chlorophyll (a+b+c)', 'Chlorophyll (a+b+c)'),
('Chlorophyll a', 'Chlorophyll a'),
('Chlorophyll a allomer', 'The phytoplankton pigment Chlorophyll a allomer'),
('Chlorophyll a, corrected for pheophytin', 'Chlorphyll a corrected for pheophytin'),
('Chlorophyll a, uncorrected for pheophytin', 'Chlorophyll a uncorrected for pheophytin'),
('Chlorophyll b', 'Chlorophyll b'),
('Chlorophyll c', 'Chlorophyll c'),
('Chlorophyll c1 and c2', 'Chlorophyll c1 and c2'),
('Chlorophyll Fluorescence', 'Chlorophyll Fluorescence'),
('Chromium (III)', 'Trivalent Chromium'),
('Chromium (VI)', 'Hexavalent Chromium'),
('Chromium, dissolved', 'Dissolved Chromium'),
('Chromium, total', 'Chromium, all forms'),
('Cobalt', 'Cobalt (Co)'),
('Cobalt, dissolved', 'Dissolved Cobalt (Co)'),
('COD', 'Chemical oxygen demand'),
('Coliform, fecal', 'Fecal Coliform'),
('Coliform, total', 'Total Coliform'),
('Color', 'Color in quantified in color units'),
('Colored Dissolved Organic Matter', 'The concentration of colored dissolved organic matter (humic substances)'),
('Container number', 'The identifying number for a water sampler container.'),
('Copper', 'Copper (Cu)'),
('Copper, dissolved', 'Dissolved Copper (Cu)'),
('Cryptophytes', 'The chlorophyll a concentration contributed by cryptophytes'),
('Cuscuta spp. coverage', 'Areal coverage of the plant Cuscuta spp.'),
('DeleteThisVar', 'A fake variable to be deleted'),
('Density', 'Density'),
('Deuterium', 'Deuterium (2H), Delta D'),
('Diadinoxanthin', 'The phytoplankton pigment Diadinoxanthin'),
('Diatoxanthin', 'The phytoplankton pigment Diatoxanthin'),
('Dinoflagellates', 'The chlorophyll a concentration contributed by Dinoflagellates'),
('Discharge', 'Discharge'),
('Distance', 'Distance measured from a sensor to a target object such as the surface of a water body or snow surface.'),
('Distichlis spicata Coverage', 'Areal coverage of the plant Distichlis spicata'),
('E-coli', 'Escherichia coli'),
('Electric Energy', 'Electric Energy'),
('Electric Power', 'Electric Power'),
('Electrical conductivity', 'Electrical conductivity'),
('Enterococci', 'Enterococcal bacteria'),
('Ethane, dissolved', 'Dissolved Ethane (C2H6)'),
('Evaporation', 'Evaporation'),
('Evapotranspiration', 'Evapotranspiration'),
('Evapotranspiration, potential', 'The amount of water that could be evaporated and transpired if there was sufficient water available.'),
('Fish detections', 'The number of fish identified by the detection equipment'),
('Flash memory error count', 'A counter which counts the number of '),
('Fluoride', 'Fluoride - F-'),
('Fluorine', 'Fluorine (F-)'),
('Fluorine, dissolved', 'Dissolved Fluorine (Fl)'),
('Friction velocity', 'Friction velocity'),
('Gage height', 'Water level with regard to an arbitrary gage datum (also see Water depth for comparison)'),
('glkjhkjhlkjh', 'Please enjkhlkh'),
('Global Radiation', 'Solar radiation, direct and diffuse, received from a solid angle of 2p steradians on a horizontal surface. \nSource: World Meteorological Organization, Meteoterm'),
('Ground heat flux', 'Ground heat flux'),
('Groundwater Depth', 'Groundwater depth is the distance between the water surface and the ground surface at a specific location specified by the site location and offset.'),
('Hardness, carbonate', 'Carbonate hardness also known as temporary hardness'),
('Hardness, non-carbonate', 'Non-carbonate hardness'),
('Hardness, total', 'Total hardness'),
('Heat index', 'The combination effect of heat and humidity on the temperature felt by people.'),
('Hydrogen sulfide', 'Hydrogen sulfide (H2S)'),
('Hydrogen-2, stable isotope ratio delta', 'Difference in the  2H:1H ratio between the sample and standard'),
('Imaginary dielectric constant', 'Soil reponse of a reflected standing electromagnetic wave of a particular frequency which is related to the dissipation (or loss) of energy within the medium. This is the imaginary portion of the complex dielectric constant.'),
('Iron sulfide', 'Iron sulfide (FeS2)'),
('Iron, dissolved', 'Dissolved Iron (Fe)'),
('Iron, ferric', 'Ferric Iron (Fe+3)'),
('Iron, ferrous', 'Ferrous Iron (Fe+2)'),
('Iva frutescens coverage', 'Areal coverage of the plant Iva frutescens'),
('JunkToDelete', 'Yessiree'),
('Latent Heat Flux', 'Latent Heat Flux'),
('Latitude', 'Latitude as a variable measurement or observation (Spatial reference to be designated in methods). '),
('Lead', 'Lead (Pb)'),
('Leaf wetness', 'The effect of moisture settling on the surface of a leaf as a result of either condensation or rainfall.'),
('Light attenuation coefficient', 'Light attenuation coefficient'),
('Limonium nashii Coverage', 'Areal coverage of the plant Limonium nashii'),
('Lithium', 'Lithium (Li)'),
('Longitude', 'Longitude as a variable measurement or observation (Spatial reference to be designated in methods). This is distinct from the longitude of a site which is a site attribute.'),
('Low battery count', 'A counter of the number of times the battery voltage dropped below a minimum threshold'),
('LSI', 'Langelier Saturation Index is an indicator of the degree of saturation of water with respect to calcium carbonate '),
('Lycium carolinianum Coverage', 'Areal coverage of the plant Lycium carolinianum'),
('Magnesium', 'Magnesium (Mg)'),
('Magnesium, dissolved', 'Dissolved Magnesium (Mg)'),
('Manganese', 'Manganese (Mn)'),
('Manganese, dissolved', 'Dissolved Manganese (Mn)'),
('Mercury', 'Mercury (Hg)'),
('Methane, dissolved', 'Dissolved Methane (CH4)'),
('Methylmercury', 'Methylmercury (CH3Hg)'),
('Molybdenum', 'Molybdenum (Mo)'),
('Momentum flux', 'Momentum flux'),
('Monanthochloe littoralis Coverage', 'Areal coverage of the plant Monanthochloe littoralis'),
('N, albuminoid', 'Albuminoid Nitrogen'),
('Net heat flux', 'Outgoing rate of heat energy transfer minus the incoming rate of heat energy transfer through a given area'),
('Nickel', 'Nickel (Ni)'),
('Nickel, dissolved', 'Dissolved Nickel (Ni)'),
('Nitrogen, Dissolved Inorganic', 'Dissolved inorganic nitrogen'),
('Nitrogen, dissolved Kjeldahl', 'Dissolved Kjeldahl (organic nitrogen + ammonia (NH3) + ammonium (NH4))nitrogen'),
('Nitrogen, dissolved nitrate (NO3)', 'Dissolved nitrate (NO3) nitrogen'),
('Nitrogen, dissolved nitrite (NO2)', 'Dissolved nitrite (NO2) nitrogen'),
('Nitrogen, dissolved nitrite (NO2) + nitrate (NO3)', 'Dissolved nitrite (NO2) + nitrate (NO3) nitrogen'),
('Nitrogen, Dissolved Organic', 'Dissolved Organic Nitrogen'),
('Nitrogen, gas', 'Gaseous Nitrogen (N2)'),
('Nitrogen, inorganic', 'Total Inorganic Nitrogen'),
('Nitrogen, NH3', 'Free Ammonia (NH3)'),
('Nitrogen, NH3 + NH4', 'Total (free+ionized) Ammonia'),
('Nitrogen, NH4', 'Ammonium (NH4)'),
('Nitrogen, nitrate (NO3)', 'Nitrate (NO3) Nitrogen'),
('Nitrogen, nitrite (NO2)', 'Nitrite (NO2) Nitrogen'),
('Nitrogen, nitrite (NO2) + nitrate (NO3)', 'Nitrite (NO2) + Nitrate (NO3) Nitrogen'),
('Nitrogen, organic', 'Organic Nitrogen'),
('Nitrogen, organic kjeldahl', 'Organic Kjeldahl (organic nitrogen + ammonia (NH3) + ammonium (NH4)) nitrogen'),
('Nitrogen, particulate organic', 'Particulate Organic Nitrogen'),
('Nitrogen, total', 'Total Nitrogen (NO3+NO2+NH4+NH3+Organic)'),
('Nitrogen, total dissolved', 'Total dissolved nitrogen'),
('Nitrogen, total kjeldahl', 'Total Kjeldahl Nitrogen (Ammonia+Organic) '),
('Nitrogen, total organic', 'Total (dissolved + particulate) organic nitrogen'),
('Nitrogen-15', '15 Nitrogen, Delta Nitrogen'),
('Nitrogen-15, stable isotope ratio delta', 'Difference in the 15N:14N ratio between the sample and standard'),
('No vegetation coverage', 'Areal coverage of no vegetation'),
('Odor', 'Odor'),
('Oxygen flux', 'Oxygen (O2) flux'),
('Oxygen, dissolved', 'Dissolved oxygen'),
('Oxygen, dissolved percent of saturation', 'Dissolved oxygen, percent saturation'),
('Oxygen, dissolved, transducer signal', 'Dissolved oxygen, raw data from sensor'),
('Oxygen-18', '18 O, Delta O'),
('Oxygen-18, stable isotope ratio delta', 'Difference in the 18O:16O ratio between the sample and standard'),
('Ozone', 'Ozone (O3)'),
('Parameter', 'Parameter related to a hydrologic process.  An example usage would be for a starge-discharge relation parameter.'),
('Peridinin', 'The phytoplankton pigment Peridinin'),
('Permittivity', 'Permittivity is a physical quantity that describes how an electric field affects, and is affected by a dielectric medium, and is determined by the ability of a material to polarize in response to the field, and thereby reduce the total electric field inside the material. Thus, permittivity relates to a material''s ability to transmit (or "permit") an electric field.'),
('Petroleum hydrocarbon, total', 'Total petroleum hydrocarbon'),
('pH', 'pH is the measure of the acidity or alkalinity of a solution. pH is formally a measure of the activity of dissolved hydrogen ions (H+).  Solutions in which the concentration of H+ exceeds that of OH- have a pH value lower than 7.0 and are known as acids. '),
('Pheophytin', 'Pheophytin (Chlorophyll which has lost the central Mg ion) is a degradation product of Chlorophyll'),
('Phosphorus, dissolved', 'Dissolved Phosphorus (P)'),
('Phosphorus, dissolved organic', 'Dissolved organic phosphorus'),
('Phosphorus, inorganic ', 'Inorganic Phosphorus'),
('Phosphorus, organic', 'Organic Phosphorus'),
('Phosphorus, orthophosphate', 'Orthophosphate Phosphorus'),
('Phosphorus, orthophosphate dissolved', 'Dissolved orthophosphate phosphorus'),
('Phosphorus, particulate', 'Particulate phosphorus'),
('Phosphorus, particulate organic', 'Particulate organic phosphorus in suspension'),
('Phosphorus, phosphate (PO4)', 'Phosphate Phosphorus'),
('Phosphorus, phosphate flux', 'Phosphate (PO4) flux'),
('Phosphorus, polyphosphate', 'Polyphosphate Phosphorus'),
('Phosphorus, total', 'Total Phosphorus'),
('Phosphorus, total dissolved', 'Total dissolved phosphorus'),
('Phytoplankton', 'Measurement of phytoplankton with no differentiation between species'),
('Position', 'Position of an element that interacts with water such as reservoir gates'),
('Potassium', 'Potassium (K)'),
('Potassium, dissolved', 'Dissolved Potassium (K)'),
('Precipitation', 'Precipitation such as rainfall. Should not be confused with settling.'),
('Pressure, absolute', 'Pressure'),
('Pressure, gauge', 'Pressure relative to the local atmospheric or ambient pressure'),
('Primary Productivity', 'Primary Productivity'),
('Program signature', 'A unique data recorder program identifier which is useful for knowing when the source code in the data recorder has been modified.'),
('Radiation, incoming longwave', 'Incoming Longwave Radiation'),
('Radiation, incoming PAR', 'Incoming Photosynthetically-Active Radiation'),
('Radiation, incoming shortwave', 'Incoming Shortwave Radiation'),
('Radiation, incoming UV-A', 'Incoming Ultraviolet A Radiation'),
('Radiation, incoming UV-B', 'Incoming Ultraviolet B Radiation'),
('Radiation, net', 'Net Radiation'),
('Radiation, net longwave', 'Net Longwave Radiation'),
('Radiation, net PAR', 'Net Photosynthetically-Active Radiation'),
('Radiation, net shortwave', 'Net Shortwave radiation'),
('Radiation, outgoing longwave', 'Outgoing Longwave Radiation'),
('Radiation, outgoing PAR', 'Outgoing Photosynthetically-Active Radiation'),
('Radiation, outgoing shortwave', 'Outgoing Shortwave Radiation'),
('Radiation, total incoming', 'Total amount of incoming radiation from all frequencies'),
('Radiation, total outgoing', 'Total amount of outgoing radiation from all frequencies'),
('Radiation, total shortwave', 'Total Shortwave Radiation'),
('Rainfall rate', 'A measure of the intensity of rainfall, calculated as the depth of water to fall over a given time period if the intensity were to remain constant over that time interval (in/hr, mm/hr, etc)'),
('Real dielectric constant', 'Soil reponse of a reflected standing electromagnetic wave of a particular frequency which is related to the stored energy within the medium.  This is the real portion of the complex dielectric constant.'),
('Recorder code', 'A code used to identifier a data recorder.'),
('Reduction potential', 'Oxidation-reduction potential'),
('Relative humidity', 'Relative humidity'),
('Reservoir storage', 'Reservoir water volume'),
('Respiration, net', 'Net respiration'),
('Salicornia bigelovii coverage', 'Areal coverage of the plant Salicornia bigelovii'),
('Salicornia virginica coverage', 'Areal coverage of the plant Salicornia virginica'),
('Salinity', 'Salinity'),
('Secchi depth', 'Secchi depth'),
('Selenium', 'Selenium (Se)'),
('Sensible Heat Flux', 'Sensible Heat Flux'),
('Sequence number', 'A counter of events in a sequence'),
('Signal-to-noise ratio', 'Signal-to-noise ratio (often abbreviated SNR or S/N) is defined as the ratio of a signal power to the noise power corrupting the signal. The higher the ratio, the less obtrusive the background noise is.'),
('Silica', 'Silica (SiO2)'),
('Silicate', 'Silicate.  Chemical compound containing silicon, oxygen, and one or more metals, e.g., aluminum, barium, beryllium, calcium, iron, magnesium, manganese, potassium, sodium, or zirconium.'),
('Silicic acid', 'Hydrated silica disolved in water'),
('Silicic acid flux', 'Silicate acid (H4SiO4) flux'),
('Silicon', 'Silicon (Si)  '),
('Silicon, dissolved', 'Dissolved Silicon (Si)'),
('Snow depth', 'Snow depth'),
('Snow Water Equivalent', 'The depth of water if a snow cover is completely melted, expressed in units of depth, on a corresponding horizontal surface area.'),
('Sodium', 'Sodium (Na)'),
('Sodium adsorption ratio', 'Sodium adsorption ratio'),
('Sodium plus potassium', 'Sodium plus potassium'),
('Sodium, dissolved', 'Dissolved Sodium (Na)'),
('Sodium, fraction of cations', 'Sodium, fraction of cations'),
('Solids, fixed Dissolved', 'Fixed Dissolved Solids'),
('Solids, fixed Suspended', 'Fixed Suspended Solids'),
('Solids, total', 'Total Solids'),
('Solids, total Dissolved', 'Total Dissolved Solids'),
('Solids, total Fixed', 'Total Fixed Solids'),
('Solids, total Suspended', 'Total Suspended Solids'),
('Solids, total Volatile', 'Total Volatile Solids'),
('Solids, volatile Dissolved', 'Volatile Dissolved Solids'),
('Solids, volatile Suspended', 'Volatile Suspended Solids'),
('Spartina alterniflora coverage', 'Areal coverage of the plant Spartina alterniflora'),
('Spartina spartinea coverage', 'Areal coverage of the plant Spartina spartinea'),
('Specific conductance', 'Specific conductance'),
('Streamflow', 'The volume of water flowing past a fixed point. '),
('Streptococci, fecal', 'Fecal Streptococci'),
('Strontium', 'Strontium (Sr)'),
('Strontium, dissolved', 'Dissolved Strontium (Sr)'),
('Strontium, total', 'Total Strontium (Sr)'),
('Suaeda linearis coverage', 'Areal coverage of the plant Suaeda linearis'),
('Suaeda maritima coverage', 'Areal coverage of the plant Suaeda maritima'),
('Sulfate', 'Sulfate (SO4)'),
('Sulfate, dissolved', 'Dissolved Sulfate (SO4)'),
('Sulfur', 'Sulfur (S)'),
('Sulfur dioxide', 'Sulfur dioxide (SO2)'),
('Sulfur, organic', 'Organic Sulfur'),
('Sulfur, pyritic', 'Pyritic Sulfur'),
('Sunshine duration', 'Sunshine duration'),
('Table overrun error count', 'A counter which counts the number of datalogger table overrun errors'),
('TDR waveform relative length', 'Time domain reflextometry, apparent length divided by probe length. Square root of dielectric'),
('Temperature', 'Temperature'),
('Temperature, dew point', 'Dew point temperature'),
('Temperature, transducer signal', 'Temperature, raw data from sensor'),
('TestingAddVar', 'Whatever we want'),
('Thallium', 'Thallium (Tl)'),
('THSW Index', 'The THSW Index uses temperature, humidity, solar radiation, and wind speed to calculate an apparent temperature.'),
('THW Index', 'The THW Index uses temperature, humidity, and wind speed to calculate an apparent temperature.'),
('Tide stage', 'Tidal stage'),
('Tin', 'Tin (Sn)'),
('Titanium', 'Titanium (Ti)'),
('Transient species coverage', 'Areal coverage of transient species'),
('Transpiration', 'Transpiration'),
('TSI', 'Carlson Trophic State Index is a measurement of eutrophication based on Secchi depth'),
('Turbidity', 'Turbidity'),
('Uranium', 'Uranium (U)'),
('Urea', 'Urea ((NH2)2CO)'),
('Urea flux', 'Urea ((NH2)2CO) flux'),
('Vanadium', 'Vanadium (V)'),
('Vapor pressure', 'The pressure of a vapor in equilibrium with its non-vapor phases'),
('Vapor pressure deficit', 'The difference between the actual water vapor pressure and the saturation of water vapor pressure at a particular temperature.'),
('Velocity', 'The velocity of a substance, fluid or object'),
('Visibility', 'Visibility'),
('Voltage', 'Voltage or Electrical Potential'),
('Volume', 'Volume. To quantify discharge or hydrograph volume or some other volume measurement.'),
('Volumetric water content', 'Volume of liquid water relative to bulk volume. Used for example to quantify soil moisture'),
('Watchdog error count', 'A counter which counts the number of total datalogger watchdog errors'),
('Water depth', 'Water depth is the distance between the water surface and the bottom of the water body at a specific location specified by the site location and offset.'),
('Water depth, averaged', 'Water depth averaged over a channel cross-section or water body. '),
('Water flux', 'Water Flux'),
('Water level', 'Water level relative to datum. The datum may be local or global such as NGVD 1929 and should be specified in the method description for associated data values.'),
('Water potential', 'Water potential is the potential energy of water relative to pure free water (e.g. deionized water) in reference conditions. It quantifies the tendency of water to move from one area to another due to osmosis, gravity, mechanical pressure, or matrix effects including surface tension.'),
('Water vapor density', 'Water vapor density'),
('Wave height', 'The height of a surface wave, measured as the difference in elevation between the wave crest and an adjacent trough.'),
('Weather conditions', 'Weather conditions'),
('Well flow rate', 'Flow rate from well while pumping'),
('Wellhead pressure', 'The pressure exerted by the fluid at the wellhead or casinghead after the well has been shut off for a period of time, typically 24 hours'),
('Wind chill', 'The effect of wind on the temperature felt on human skin.'),
('Wind direction', 'Wind direction'),
('Wind gust direction', 'Direction of gusts of wind'),
('Wind gust speed', 'Speed of gusts of wind'),
('Wind Run', 'The length of flow of air past a point over a time interval. Windspeed times the interval of time.'),
('Wind speed', 'Wind speed'),
('Wind stress', 'Drag or trangential force per unit area exerted on a surface by the adjacent layer of moving air'),
('Wrack coverage', 'Areal coverage of dead vegetation'),
('Zeaxanthin', 'The phytoplankton pigment Zeaxanthin'),
('Zinc', 'Zinc (Zn)'),
('Zinc, dissolved', 'Dissolved Zinc (Zn)'),
('Zircon, dissolved', 'Dissolved Zircon (Zr)'),
('Zooplankton', 'Zooplanktonic organisms, non-specific');

-- --------------------------------------------------------

--
-- Table structure for table `variables`
--

DROP TABLE IF EXISTS `variables`;
CREATE TABLE IF NOT EXISTS `variables` (
  `VariableID` int(11) NOT NULL AUTO_INCREMENT,
  `VariableCode` varchar(50) NOT NULL,
  `VariableName` varchar(255) NOT NULL,
  `Speciation` varchar(255) NOT NULL DEFAULT 'Not Applicable',
  `VariableunitsID` int(11) NOT NULL,
  `SampleMedium` varchar(255) NOT NULL DEFAULT 'Unknown',
  `ValueType` varchar(255) NOT NULL DEFAULT 'Unknown',
  `IsRegular` tinyint(1) NOT NULL DEFAULT '0',
  `TimeSupport` double NOT NULL DEFAULT '0',
  `TimeunitsID` int(11) NOT NULL DEFAULT '0',
  `DataType` varchar(255) NOT NULL DEFAULT 'Unknown',
  `GeneralCategory` varchar(255) NOT NULL DEFAULT 'Unknown',
  `NoDataValue` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`VariableID`),
  UNIQUE KEY `AK_Variables_VariableCode` (`VariableCode`),
  KEY `VariableunitsID` (`VariableunitsID`),
  KEY `TimeunitsID` (`TimeunitsID`),
  KEY `DataType` (`DataType`),
  KEY `GeneralCategory` (`GeneralCategory`),
  KEY `SampleMedium` (`SampleMedium`),
  KEY `ValueType` (`ValueType`),
  KEY `VariableName` (`VariableName`),
  KEY `Speciation` (`Speciation`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;



--
-- Table structure for table `varmeth`
--

DROP TABLE IF EXISTS `varmeth`;
CREATE TABLE IF NOT EXISTS `varmeth` (
  `VariableID` varchar(50) NOT NULL,
  `VariableCode` varchar(25) NOT NULL,
  `VariableName` varchar(50) NOT NULL,
  `DataType` varchar(50) NOT NULL,
  `MethodID` varchar(50) DEFAULT NULL,
  KEY `VariableID` (`VariableID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Index to connect variables to specific methods for narrowing';



--
-- Table structure for table `verticaldatumcv`
--

DROP TABLE IF EXISTS `verticaldatumcv`;
CREATE TABLE IF NOT EXISTS `verticaldatumcv` (
  `Term` varchar(255) NOT NULL,
  `Definition` text,
  PRIMARY KEY (`Term`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `verticaldatumcv`
--

INSERT INTO `verticaldatumcv` (`Term`, `Definition`) VALUES
('MSL', 'Mean Sea Level'),
('NAVD88', 'North American Vertical Datum of 1988'),
('NGVD29', 'National Geodetic Vertical Datum of 1929'),
('Something', 'The vertical datum is unknown.'),
('Unknown', 'The vertical datum is unknown');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `FK_Categories_Variables` FOREIGN KEY (`VariableID`) REFERENCES `variables` (`VariableID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `datavalues`
--
ALTER TABLE `datavalues`
  ADD CONSTRAINT `FK_DataValues_censorcodecv` FOREIGN KEY (`CensorCode`) REFERENCES `censorcodecv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_methods` FOREIGN KEY (`MethodID`) REFERENCES `methods` (`MethodID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_OffsetTypes` FOREIGN KEY (`OffsetTypeID`) REFERENCES `offsettypes` (`OffsetTypeID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_Qualifiers` FOREIGN KEY (`QualifierID`) REFERENCES `qualifiers` (`QualifierID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_qualitycontrollevels` FOREIGN KEY (`QualityControlLevelID`) REFERENCES `qualitycontrollevels` (`QualityControlLevelID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_Samples` FOREIGN KEY (`SampleID`) REFERENCES `samples` (`SampleID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_Sites` FOREIGN KEY (`SiteID`) REFERENCES `sites` (`SiteID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_DataValues_Sources` FOREIGN KEY (`SourceID`) REFERENCES `sources` (`SourceID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_DataValues_Variables` FOREIGN KEY (`VariableID`) REFERENCES `variables` (`VariableID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `derivedfrom`
--
ALTER TABLE `derivedfrom`
  ADD CONSTRAINT `FK_DerivedFrom_DataValues` FOREIGN KEY (`ValueID`) REFERENCES `datavalues` (`ValueID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `groups`
--
ALTER TABLE `groups`
  ADD CONSTRAINT `FK_Groups_DataValues` FOREIGN KEY (`ValueID`) REFERENCES `datavalues` (`ValueID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Groups_GroupDescriptions` FOREIGN KEY (`GroupID`) REFERENCES `groupdescriptions` (`GroupID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `isometadata`
--
ALTER TABLE `isometadata`
  ADD CONSTRAINT `FK_isometadata_topiccategorycv` FOREIGN KEY (`TopicCategory`) REFERENCES `topiccategorycv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `offsettypes`
--
ALTER TABLE `offsettypes`
  ADD CONSTRAINT `FK_OffsetTypes_units` FOREIGN KEY (`OffsetunitsID`) REFERENCES `units` (`unitsID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `samples`
--
ALTER TABLE `samples`
  ADD CONSTRAINT `FK_Samples_labmethods` FOREIGN KEY (`LabMethodID`) REFERENCES `labmethods` (`LabMethodID`),
  ADD CONSTRAINT `FK_Samples_sampletypecv` FOREIGN KEY (`SampleType`) REFERENCES `sampletypecv` (`Term`);

--
-- Constraints for table `sites`
--
ALTER TABLE `sites`
  ADD CONSTRAINT `FK_Sites_sitetypecv` FOREIGN KEY (`SiteType`) REFERENCES `sitetypecv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Sites_spatialreferences` FOREIGN KEY (`LatLongDatumID`) REFERENCES `spatialreferences` (`SpatialReferenceID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Sites_spatialreferences1` FOREIGN KEY (`LocalProjectionID`) REFERENCES `spatialreferences` (`SpatialReferenceID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Sites_verticaldatumcv` FOREIGN KEY (`VerticalDatum`) REFERENCES `verticaldatumcv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `sources`
--
ALTER TABLE `sources`
  ADD CONSTRAINT `FK_Sources_ISOMetaData` FOREIGN KEY (`MetadataID`) REFERENCES `isometadata` (`MetadataID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Constraints for table `variables`
--
ALTER TABLE `variables`
  ADD CONSTRAINT `FK_Variables_datatypecv` FOREIGN KEY (`DataType`) REFERENCES `datatypecv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_GeneralCategoryCV` FOREIGN KEY (`GeneralCategory`) REFERENCES `generalcategorycv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_samplemediumcv` FOREIGN KEY (`SampleMedium`) REFERENCES `samplemediumcv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_speciationcv` FOREIGN KEY (`Speciation`) REFERENCES `speciationcv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_units` FOREIGN KEY (`VariableunitsID`) REFERENCES `units` (`unitsID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_Variables_units1` FOREIGN KEY (`TimeunitsID`) REFERENCES `units` (`unitsID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_valuetypecv` FOREIGN KEY (`ValueType`) REFERENCES `valuetypecv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `FK_Variables_variablenamecv` FOREIGN KEY (`VariableName`) REFERENCES `variablenamecv` (`Term`) ON DELETE NO ACTION ON UPDATE NO ACTION;

